macro to force auto full screen

[copythat]

I am looking for somebody who can help me for this. I would like to start workbook with auto full screen mode by using the code shown below.

This code is nicely working when I use Private Sub worksheet_selection() but not with _Activate(). Could anybody help me?.

Private Sub Worksheet_Activate()
    Application.DisplayFormulaBar = False
    ActiveWindow.DisplayHeadings = False
    ActiveWindow.DisplayGridlines = False
    Application.DisplayFullScreen = True
End Sub

Thanks,

[john55]

hi,
try this

Private Sub Workbook_Open()
 Application.DisplayFormulaBar = False
    ActiveWindow.DisplayHeadings = False
    ActiveWindow.DisplayGridlines = False
    Application.DisplayFullScreen = True
End Sub

and add yr code (e.g) to Sheet1 (Private Sub Worksheet_Activate())

[copythat]

john55
it's working well. Thank you so much!!!

[ConneXionLost]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save