As you can see, I already have this command in the workbooks AUTO_OPEN - thus:
Sub auto_open()
With ActiveWindow
.DisplayGridlines = False
.DisplayHeadings = False
.DisplayZeros = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
Application.DisplayFullScreen = True
End Sub
Private Sub Auto_Open()
With ActiveWindow
.DisplayHeadings = False
.DisplayHorizontalScrollBar = False
.DisplayVerticalScrollBar = False
.DisplayWorkbookTabs = False
End With
With Application
.DisplayStatusBar = False
.CommandBars("Worksheet Menu Bar").Enabled = False
.DisplayFullScreen = True
.DisplayFormulaBar = False
End With
End Sub
Don't forget to code to change reset when the workbook is closed.
Or you can use Thisworkbook Activate and Deactivate events as Simon points
out.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
