View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default resizing excel window

Might be easier to just hide it and then make it visible again. (assume you
splash screen is a userform)

Application.visible = False


Application.Visible = True

--
Regards,
Tom Ogilvy


"JNW" wrote in message
...
I have a workbook with a splashscreen that appears before a login form
appears. After the login, I want to reduce the size of Excel's window,

not
just the workbook window. I've searched and could only find a
workbook-resize event but no way to change the application window size.

Any Ideas?