Maximise My Excel Window on startup?

[dimm]

Hi folks,

I want to put code into my AutoOpen macro to maximise my workbooks excel
window. If someone could help me please I'd appreciate it?

PS: I have a feeling it ends with = xlmaximise....but thats just a guess...

PPS: My old username used to be 'dim' but for some reason I couldn't post so
I had to set up this new account...whats going on with the server? :-(

 

[Gary''s Student]

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

 

[dimm]

FANTASTIC! That was quick. thanks Gary's student. ;-)

 

[JLGWhiz]

In case you didn't want to lose your status bar, tool bars, etc. the other
one is:

Application.WindowState = xlMaximized

That does the same as clicking the screen icon at the tip right.