bamaisgreat
Well-known Member
- Joined
- Jan 23, 2012
- Messages
- 831
- Office Version
- 365
- Platform
- Windows
I am attempting in the code below so when I run the macro it will zoom to 50 and minimize then when I run the macro again it will zoom to 90 and maximize. Please help me get the code correct. Thanks as always
Code:
Sub ribb_zoom()
CommandBars.ExecuteMso "MinimizeRibbon"
ActiveWindow.zoom = 50
Else
CommandBars.ExecuteMso "MinimizeRibbon"
ActiveWindow.zoom = 90
End Sub