I have an Excel spreadsheet that runs on my Windows PC and have been easily able to use VBA to completely hide the Toolbar ribbon. I have not been able to find a way for doing this using VBA on my Macbook Air.
I have carried out several searches on the Internet and have not yet found a solution.
Is this just a limitation of VBA for Macbooks or is there a way of achieving this using VBA? See screenshots attached illustrating the difference between Macbook Air and PC.
Current code:
With Application
.DisplayFullScreen = True
.CommandBars("Full Screen").Visible = False
.CommandBars("Worksheet Menu Bar").Enabled = False
.DisplayFormulaBar = False
End With
No comments:
Post a Comment