Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a fancy way to open a workbook in a minimized window stat
Hi,
I have written a VBA application that initially open 3 workbooks - one of them in a minimized state. The application then open several selected workbooks . Each workbook is minimized, modified and closed before the next workbook is opened. Even if I'm using the ActiveWindow.WindowState = xlMinimized, each workbook keep flashing up a moment on the screen before it is minimized, and it looks quite disturbing. What I need i a way to open a selected workbook in a minimized way. How can this be done ? Regards Frank |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a fancy way to open a workbook in a minimized window stat
Just curious, but why does the workbook need to be minimised?
If it is because you don't want the user to see the workbooks opening andd closing, you could put application.screenupdating = false at the start of your code, then put it back to true at the end. "Frank Krogh" wrote: Hi, I have written a VBA application that initially open 3 workbooks - one of them in a minimized state. The application then open several selected workbooks . Each workbook is minimized, modified and closed before the next workbook is opened. Even if I'm using the ActiveWindow.WindowState = xlMinimized, each workbook keep flashing up a moment on the screen before it is minimized, and it looks quite disturbing. What I need i a way to open a selected workbook in a minimized way. How can this be done ? Regards Frank |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there a fancy way to open a workbook in a minimized window
Thank you for your logic question - it's the simple, but perfect solution.
regards Frank I just turn on the "George J" wrote: Just curious, but why does the workbook need to be minimised? If it is because you don't want the user to see the workbooks opening andd closing, you could put application.screenupdating = false at the start of your code, then put it back to true at the end. "Frank Krogh" wrote: Hi, I have written a VBA application that initially open 3 workbooks - one of them in a minimized state. The application then open several selected workbooks . Each workbook is minimized, modified and closed before the next workbook is opened. Even if I'm using the ActiveWindow.WindowState = xlMinimized, each workbook keep flashing up a moment on the screen before it is minimized, and it looks quite disturbing. What I need i a way to open a selected workbook in a minimized way. How can this be done ? Regards Frank |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Open new workbook(s) when userform and excel are minimized | Excel Programming | |||
Help window opens minimized | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) | |||
Running Macro in Minimized Excel Window | Excel Programming | |||
show the form as minimized window | Excel Programming |