Setting DisplayFullScreen in Excel: 2 issues

I want to set Excel to use full screen mode immediately the workbook opens. In a test spreadsheet I have used both of these approaches (independently):

1. Create a macro called Auto_Open and record the mouse actions View | Full Screen
2. Use the VBA code:

Private Sub Workbook_Open()
Application.DisplayFullScreen = True
End Sub

In the test workbook both methods work fine. However I don't want the floating "Close full screen" box to be displayed.

Question 1: Is there any way to inhibit this box

On my real application, method 1 works OK but method 2 does not work - ie the full screen mode is not invoked.

Question 2: Any ideas why method 2 (which I would prefer to use if possible) should fail There are no other macros or event handlers that affect the workbook or the sheet which is visible when the workbook opens. I appreciate that this may be difficult without knowing what other code is there (there's a lot). But perhaps there are some general problems

I want solutions to work in Office 97 through Office 2007. Please!

Thanks for your suggestions

Rob2xx2

Answer this question

Setting DisplayFullScreen in Excel: 2 issues

Rajnesh
Thank you Duck Thing! And I learned about the CommandBars object too. Great help!
StSt

Glad to be of service
Alan Zhou
rob2xx2 wrote:

Question 1: Is there any way to inhibit this box

Yes. This code should do the trick:

Application.DisplayFullScreen = True
Application.CommandBars("Full Screen").Visible = False
Setting DisplayFullScreen in Excel: 2 issues

Answer this question