Maximise My Excel Window on startup?
 

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? :-(

Maximise My Excel Window on startup?
 

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

--
Gary''s Student - gsnu200770

Maximise My Excel Window on startup?
 

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

"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu200770

Maximise My Excel Window on startup?
 

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.

"dimm" wrote:

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

"Gary''s Student" wrote:

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

--
Gary''s Student - gsnu200770