Make the worksheet run in full screen mode on open
Posted by Phil on June 01, 2001 7:54 AM
Hi
does any1 know how to Make the a worksheet run in full screen mode when it is opened
Posted by David Rainey on June 01, 2001 7:55 AM
place this in the thisworkbook module
Private Sub Workbook_Open()
Application.WindowState = xlMaximized
ActiveWindow.WindowState = xlMaximized
End Sub
Posted by Phil on June 01, 2001 8:11 AM
soory i think i've phrased it wrong
I am trying to get it to open up to full screen Mode....
Similar to pressing "alt+v" then "u"
Cheers
Phil
Posted by David Rainey on June 01, 2001 8:15 AM
Re: soory i think i've phrased it wrong
Application.DisplayFullScreen = True
Posted by Phil on June 01, 2001 8:32 AM
Thanxs
Cheers - worked a treat....
