Display a range fullscreen

  • Thread starter Thread starter Stuart
  • Start date Start date
S

Stuart

How can I use the WorkBook_Open Event to
force a range (say "A1:N60") to display fullscreen
when the workbook opens, please?

There is only one sheet in the book.

I've tried manually using View>FullScreen, but
this seems to obliterate the toolbars.

Regards.
 
sounds like you just want to maximize the application window

application.Windows(1).WindowState =xlMaximized
and perhaps the workbook as well

Thisworkbook.Windows(1).WindowState = xlMaximized
 
That does it.

Many thanks.

Tom Ogilvy said:
sounds like you just want to maximize the application window

application.Windows(1).WindowState =xlMaximized
and perhaps the workbook as well

Thisworkbook.Windows(1).WindowState = xlMaximized
Click to expand...
 
Back
Top