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?

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" <PCakes@discussions.microsoft.com> wrote in message
news:7BCDE2E9-5E59-434B-8694-7956CFD8917D@microsoft.com...
>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?

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" <PCakes@discussions.microsoft.com> wrote in message
> news:7BCDE2E9-5E59-434B-8694-7956CFD8917D@microsoft.com...
> >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?
>
>
>

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" <PCakes@discussions.microsoft.com> wrote in message
news:3F82E45B-A936-4F2F-810A-0A34EC142755@microsoft.com...
> 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" <PCakes@discussions.microsoft.com> wrote in message
> > news:7BCDE2E9-5E59-434B-8694-7956CFD8917D@microsoft.com...
> > >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?
> >
> >
> >