Enter CTRL F1 using code

santosm
3StarLounger
Posts: 253
Joined: 19 Apr 2010, 09:01
Location: Indiana, USA

Enter CTRL F1 using code

Post by santosm »

Is there a way to enter a <CTRL>F1 in code? This would minimize the ribbon which is of no use for 99% of my users and would allow a bump in screen space.

Office 2010!

Thanks,
Mark
Thanks,
Mark

User avatar
HansV
Administrator
Posts: 78622
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Enter CTRL F1 using code

Post by HansV »

DoCmd.ShowToolbar "Ribbon", acToolbarNo

hides the ribbon and the Quick Access Toolbar, and

DoCmd.ShowToolbar "Ribbon", acToolbarYes

shows it again.
Best wishes,
Hans

User avatar
HansV
Administrator
Posts: 78622
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Enter CTRL F1 using code

Post by HansV »

To minimize the ribbon instead of completely hiding it, you can use

CommandBars.ExecuteMso "MinimizeRibbon"
Best wishes,
Hans

santosm
3StarLounger
Posts: 253
Joined: 19 Apr 2010, 09:01
Location: Indiana, USA

Re: Enter CTRL F1 using code

Post by santosm »

Thanks Hans!!!
Thanks,
Mark