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 |
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 |
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 |
All times are GMT +1. The time now is 01:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com