Display a range fullscreen
 

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 ViewFullScreen, but
this seems to obliterate the toolbars.

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004

Display a range fullscreen
 

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

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
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 ViewFullScreen, but
this seems to obliterate the toolbars.

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004

Display a range fullscreen
 

That does it.

Many thanks.

"Tom Ogilvy" wrote in message
...
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

--
Regards,
Tom Ogilvy

"Stuart" wrote in message
...
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 ViewFullScreen, but
this seems to obliterate the toolbars.

Regards.


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004






---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.719 / Virus Database: 475 - Release Date: 12/07/2004