Preventing Macro Flash
 

I have recorded a macro, how do I stop it from showing all the steps I have
taken and simply run the macro? Do I use DIM if sho what is the correct way
of doing so?

Preventing Macro Flash
 

PCakes,

Application.ScreenUpdating = False

'Your code

Application.ScreenUpdating = True
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"PCakes" wrote in message
...
I have recorded a macro, how do I stop it from showing all the steps I have
taken and simply run the macro? Do I use DIM if sho what is the correct
way
of doing so?

Preventing Macro Flash
 

Thank you! I am trying to teach myself some Visual Basics, but time is not
on my side. This site is most helpful as are you!

"Paul B" wrote:

PCakes,

Application.ScreenUpdating = False

'Your code

Application.ScreenUpdating = True
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"PCakes" wrote in message
...
I have recorded a macro, how do I stop it from showing all the steps I have
taken and simply run the macro? Do I use DIM if sho what is the correct
way
of doing so?

Preventing Macro Flash
 

Your welcome

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"PCakes" wrote in message
...
Thank you! I am trying to teach myself some Visual Basics, but time is
not
on my side. This site is most helpful as are you!

"Paul B" wrote:

PCakes,

Application.ScreenUpdating = False

'Your code

Application.ScreenUpdating = True
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003


"PCakes" wrote in message
...
I have recorded a macro, how do I stop it from showing all the steps I
have
taken and simply run the macro? Do I use DIM if sho what is the
correct
way
of doing so?