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?
|