Toolbars, help needed

[Brian]

I would like to have a workbook that opens in full screen, but only for this
particular workbook and not in other Excel workbooks.

 

[Nick Hodge]

Brian

You could use the workbook_Open() and close() events as in the code below.
This would switch on full screen when opening and restore when closing. To
enter the code, right-click the excel icon at the top left of the workbook
and select 'View code...'. Then paste the code in resultant window, close
the VBE and save the workbook

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

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayFullScreen = False
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]

 

[Brian]

Thank you Nick Worked Great

Brian

You could use the workbook_Open() and close() events as in the code below.
This would switch on full screen when opening and restore when closing.
To enter the code, right-click the excel icon at the top left of the
workbook and select 'View code...'. Then paste the code in resultant
window, close the VBE and save the workbook

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

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.DisplayFullScreen = False
End Sub

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]