| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display cell value in a range | Excel Discussion (Misc queries) | |||
| Display Dynamic Range | Excel Worksheet Functions | |||
| useform autosize to fullscreen problem | Excel Worksheet Functions | |||
| How do I reset default Excel window too view=fullscreen | Setting up and Configuration of Excel | |||
| Display set range | Excel Programming | |||
![Stuart[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
