Using Frames on macros

Macker72 · Apr 30th, 2002, 02:33 AM

Hi
I have a long macro with lots of graphical work. when i run the macro the screen shows all the different steps in a flash, i have been told that if i switch frames off it will stop this flashing effect. can you help explain?
Thanks
Macker

AJ · Apr 30th, 2002, 03:37 AM

I'm not sure what's meant by frames, but if you put
Application.ScreenUpdating = False
at the top of the macro then (as it implies) it will stop anything showing while the macro runs

Macker72 · Apr 30th, 2002, 08:48 AM

thanks AJ, just what i wanted

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

Apr 30th, 2002, 02:33 AM	#1
Macker72 Board Regular Join Date: Mar 2002 Posts: 107	Hi I have a long macro with lots of graphical work. when i run the macro the screen shows all the different steps in a flash, i have been told that if i switch frames off it will stop this flashing effect. can you help explain? Thanks Macker

Apr 30th, 2002, 03:37 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	I'm not sure what's meant by frames, but if you put Application.ScreenUpdating = False at the top of the macro then (as it implies) it will stop anything showing while the macro runs

Apr 30th, 2002, 08:48 AM	#3
Macker72 Board Regular Join Date: Mar 2002 Posts: 107	thanks AJ, just what i wanted