how do I get rid of the "full screen mode off" button
how do I get rid of the "full screen mode off" button
(OP)
I am writing a excel database with the use of VB. In some of my user screens I use the full screen mode in Excel. Ny question is as follows.
Is it possible to get rid of that floating button to turn off full screen mode. I'm only new to VB and there is probably a simple way to do this. I hope someone can help me.
Thanks in advance.
Crash
Is it possible to get rid of that floating button to turn off full screen mode. I'm only new to VB and there is probably a simple way to do this. I hope someone can help me.
Thanks in advance.
Crash





RE: how do I get rid of the "full screen mode off" button
Try the following:
Application.CommandBars("Full Screen").Visible = False
You may need to execute this immediately after entering "Full Screen" mode, rather than before.
Hope this helps.
M. Smith
RE: how do I get rid of the "full screen mode off" button
Application.WindowState = xlMinimized
'The value can be: xlMaximized, xlMinimized, or xlNormal