Display a range fullscreen

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

 

[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

 

[Stuart]

That does it.

Many thanks.

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