Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run in Minimised Window
Hi all
I put a shortcut on my desktop and changed its properties to run to a minimise window however it still opens excel in a normal window, is there any way to fix this? Jason |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run in Minimised Window
Hi,
You could put this in the workbook_open event Private Sub Workbook_Open() Application.WindowState = xlMinimized End Sub Mike "Jason Zischke" wrote: Hi all I put a shortcut on my desktop and changed its properties to run to a minimise window however it still opens excel in a normal window, is there any way to fix this? Jason |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Run in Minimised Window
Hi Mike
Thanks for your responce, however I don't wont the excel window to show at all until I have set the window up for the user's use that is why I tried this and then later in my code I put Application.WindowState = xlMaximized and on one computer it would work fine however on another computer it wouldn't. Jason "Mike H" wrote: Hi, You could put this in the workbook_open event Private Sub Workbook_Open() Application.WindowState = xlMinimized End Sub Mike "Jason Zischke" wrote: Hi all I put a shortcut on my desktop and changed its properties to run to a minimise window however it still opens excel in a normal window, is there any way to fix this? Jason |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Docking Project Explorer, Properties window and Code window in VBE | Setting up and Configuration of Excel | |||
The window opens in a smaller window not full sized window. | Excel Discussion (Misc queries) | |||
Unable to keep the Ribbon always minimised | Excel Discussion (Misc queries) | |||
In Excel - how to delete new window created from window on tool ba | Excel Worksheet Functions | |||
How do I undo the Excel, Window Menu, New Window command | Excel Discussion (Misc queries) |