Forum Discussion
Macro Code help?
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").Se...
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:
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
- Again, thank you for your help! That still did not work. However, I found that this combination of code does what I require. All the best, my colleague.
ActiveWindow.WindowState = xlMinimized
Application.WindowState = xlNormal