MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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