| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Opening Workbooks Mininmized
Is there a setting that when I open a workbook it is automatically
minimized? I have 15 workbooks that I open all at once and have to minimize each one seperately. Thanks. |
|
#2
|
|||
|
|||
|
Hi
In the Workbook_Open sub of each workbook put Application.ActiveWindow.WindowState = xlMinimized Save and close the file. Now each time it is opened, it will open minimized. HTH Ken |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| open multiple workbooks at startup | Excel Discussion (Misc queries) | |||
| Workbooks...I'll try this again... | Excel Discussion (Misc queries) | |||
| Slow opening files - possible cause and solutoin | Excel Discussion (Misc queries) | |||
| References to open/hidden workbooks become hard-coded in formulas - 2003 | Excel Discussion (Misc queries) | |||
| Summing Values from different workbooks | Excel Discussion (Misc queries) | |||
Linear Mode
