View Single Post
  #2   Report Post  
Nick Hodge
 
Posts: n/a
Default

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.