Toolbars, help needed
 

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

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
HIS

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

Thank you Nick Worked Great


"Nick Hodge" wrote in message
...
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
HIS

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