Jeffrey Mahoney
Well-known Member
- Joined
- May 31, 2015
- Messages
- 3,130
- Office Version
- 365
- Platform
- Windows
Is there a VBA equivalent to CTRL-SHIFT-F1 which hides the ribbon and the statusbar? That keyboard shortcut is great because I can still click on the black bar at the top to see the full ribbon.
The only code I've found is below. No mouse use and no keyboard shortcut to reverse.
Sendkeys did not work for me using Application.Sendkeys "+^{F1}"
The only code I've found is below. No mouse use and no keyboard shortcut to reverse.
Sendkeys did not work for me using Application.Sendkeys "+^{F1}"
VBA Code:
Public FullScreen As Boolean
Sub ToggleFullScreen()
FullScreen = Abs(FullScreen) - 1
Application.DisplayFullScreen = FullScreen
End Sub