ActiveWindow.WindowState = xlMinimized

nehpets12 · May 15th, 2002, 05:33 AM

I am using a macro that copies and pastes data to a worksheet this takes quite a long time. I can speed it up if I use ActiveWindow.WindowState = xlMinimized
then use
ActiveWindow.WindowState = xlMaximized
when it has finished. This works fine if this is the only active workbook open but does not if I have another workbook open at the same time.

Any Ideas how to correct this problem ?

Russell · May 15th, 2002, 05:47 AM

You could try using:
Application.ScreenUpdating = False
and
Application.ScreenUpdating = True
around your code.

Russell

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 15th, 2002, 05:33 AM	#1
nehpets12 Board Regular Join Date: Feb 2002 Posts: 422	I am using a macro that copies and pastes data to a worksheet this takes quite a long time. I can speed it up if I use ActiveWindow.WindowState = xlMinimized then use ActiveWindow.WindowState = xlMaximized when it has finished. This works fine if this is the only active workbook open but does not if I have another workbook open at the same time. Any Ideas how to correct this problem ?

May 15th, 2002, 05:47 AM	#2
Russell New Member Join Date: Mar 2002 Posts: 39	You could try using: Application.ScreenUpdating = False and Application.ScreenUpdating = True around your code. Russell