View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
ryguy7272 ryguy7272 is offline
external usenet poster
 
Posts: 2,836
Default Macro for Full Screen

Alt + F11

Put the code into ThisWorkbook

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

Save and Open

HTH,
Ryan---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Masters" wrote:

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

"ryguy7272" wrote:

Just put the code in 'ThisWorkbook':

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

If this post is helpful, please click 'Yes'
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Masters" wrote:

That is great, how can I make this Macro run automatically when the workbook
is opened up?

"ryguy7272" wrote:

Simple:

Sub FS()
Application.DisplayFullScreen = True
End Sub

HTH,
Ryan--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Masters" wrote:

Is there a VB code to turn on and off Full Sceen view?