Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations cowski on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

how do I get rid of the "full screen mode off" button 1

Status
Not open for further replies.

Crashtestdummy

Materials
May 8, 2002
10
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
 
Replies continue below

Recommended for you

Crash,

Try the following:

Code:
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
 
Try this:

Application.WindowState = xlMinimized
'The value can be: xlMaximized, xlMinimized, or xlNormal
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor