Mar 31 2024 07:19 AM
I would like to build a macro that restores my screen view to include the toolbar. Any help appreciated. Here's my code currently:
Sub Assets()
'
' Page Macro
' Assets
'
'
Sheets("Assets").Select
Application.WindowState = xlNormal
Application.DisplayFullScreen = True
Range("A1").Select
' DoCmd.ShowToolbar "Ribbon", acToolbarYes ??????? Not sure how to use this or if appropriate.
End Sub
Mar 31 2024 07:52 AM
DoCmd.ShowToolbar does not work in Excel; it is for Microsoft Access.
To show the ribbon, you can use
ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",TRUE)"
(And the same line with FALSE instead of TRUE hides the ribbon)
Mar 31 2024 04:02 PM
I do thank you for your reply. Perhaps I have asked for the wrong term for your solution still does not display what I seek. So below I will post what I get with the routine and then what I would like to see with the routine, if you could advise further, thank you.
With the code as mentioned:
What I would like to have displayed:
Apr 01 2024 02:28 AM
Thanks for the screenshots. The one at the top shows Excel in Full Screen Mode.
To turn off Full Screen Mode, use
Application.DisplayFullScreen = False
And if you want to turn it on:
Application.DisplayFullScreen = True
Apr 01 2024 07:04 AM