Display a range fullscreen

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

Tom Ogilvy

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
 
S

Stuart

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