Macro for Full Screen

  • Thread starter Thread starter Masters
  • Start date Start date
That is great, how can I make this Macro run automatically when the workbook
is opened up?
 
Just put the code in 'ThisWorkbook':

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

If this post is helpful, please click 'Yes'
Ryan--
 
Here is what I got and it doesn't go to full screen when I open it???

Sub Open_()
'
' Open_ Macro
'

'
Private Sub Workbook_Open()
Application.DisplayFullScreen = True
End Sub
 
Alt + F11

Put the code into ThisWorkbook

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

Save and Open

HTH,
Ryan---
 
The code must reside in the ThisWorkbook module. It won't work if it
resides in any other module. Also, the name of the procedure is
"Workbook_Open", not "Open_". And, of course, it won't work in VBA
procedures are disabled.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)
 
Back
Top