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

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

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