Run in Minimised Window

J

Jason Zischke

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
 
M

Mike H

Hi,

You could put this in the workbook_open event

Private Sub Workbook_Open()
Application.WindowState = xlMinimized
End Sub

Mike
 
J

Jason Zischke

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
 
Top