Thread: Display a range fullscreen
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
  
Posts: 27,285
Default 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




Reply With QuoteReply With Quote