ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Can you turn off the Full Screen toolbar? (https://www.excelbanter.com/excel-programming/437555-can-you-turn-off-full-screen-toolbar.html)

michael.beckinsale

Can you turn off the Full Screen toolbar?
 
Hi All,

I lam ooking at the possibility of turning Full Screen view on & off
rather than deleting & restoring the users existing menu's.

Can anybody tell me if the floating 'Full Screen' toolbar can be
turned off, and if so what is the code?

Regards

Michael

Peter T

Can you turn off the Full Screen toolbar?
 
Sub FullScreenBar(bVis As Boolean)
CommandBars("Full Screen").Visible = bVis
End Sub

Regards,
Peter T

"michael.beckinsale" wrote in message
...
Hi All,

I lam ooking at the possibility of turning Full Screen view on & off
rather than deleting & restoring the users existing menu's.

Can anybody tell me if the floating 'Full Screen' toolbar can be
turned off, and if so what is the code?

Regards

Michael




michael.beckinsale

Can you turn off the Full Screen toolbar?
 
Hi Peter,

This menu stuff can be confusing!

Why does your code work and the following does not?

CommandBars("Full Screen").Visible = False

Regards

Michael

Peter T

Can you turn off the Full Screen toolbar?
 
Absolute no reason for that discrepancy at all, assuming 'bVis = false' it's
exactly the same.
What error message do you get.

Maybe this might be of use to you, but be very careful not to leave user
stranded

Application.DisplayFullScreen = true/false ' read/write

Regards,
Peter T



"michael.beckinsale" wrote in message
...
Hi Peter,

This menu stuff can be confusing!

Why does your code work and the following does not?

CommandBars("Full Screen").Visible = False

Regards

Michael





All times are GMT +1. The time now is 08:09 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com