macro to force auto full screen

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?.

Please Login or Register  to view this content.

Thanks,

hi,
try this

Please Login or Register  to view this content.

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

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