Don't show sheet switches when running macro

Hi,
Is there some code that will enable me to run a macro without excel
switching between the various sheets that are used.
Essentially I want to be able to click the button for the macro and the
sheet to update without all the others being displayed as the macro runs.
Thanks for any help
Ben

Ben

You can use Application.ScreenUpdating = False, setting it back to True at
the end of the macro.

You can also write your code in such a way that other sheets aren't
activated, as described here
http://www.*****-blog.com/archives/2...-and-activate/

--
**** Kusleika
Excel MVP
Daily Dose of Excel
www.*****-blog.com

Ben wrote:
> Hi,
> Is there some code that will enable me to run a macro without excel
> switching between the various sheets that are used.
> Essentially I want to be able to click the button for the macro and
> the sheet to update without all the others being displayed as the
> macro runs. Thanks for any help
> Ben

Application.ScreenUpdating = False
Your code
Application.screenUpdating=true
will do it

Alok Joshi
"Ben" wrote:

> Hi,
> Is there some code that will enable me to run a macro without excel
> switching between the various sheets that are used.
> Essentially I want to be able to click the button for the macro and the
> sheet to update without all the others being displayed as the macro runs.
> Thanks for any help
> Ben

Solved this now!!
I used "Application.ScreenUpdating = False"
If anyones interested!!

"Ben" wrote:

> Hi,
> Is there some code that will enable me to run a macro without excel
> switching between the various sheets that are used.
> Essentially I want to be able to click the button for the macro and the
> sheet to update without all the others being displayed as the macro runs.
> Thanks for any help
> Ben

A much better way is to do what **** advised!!!!! Rewrite you code so it
doesn't do the selecting and activating!!!!!

If your interested!!!!!!

--
Regards,
Tom Ogilvy



"Ben" <[email protected]> wrote in message
news:[email protected]...
> Solved this now!!
> I used "Application.ScreenUpdating = False"
> If anyones interested!!
>
> "Ben" wrote:
>
> > Hi,
> > Is there some code that will enable me to run a macro without excel
> > switching between the various sheets that are used.
> > Essentially I want to be able to click the button for the macro and the
> > sheet to update without all the others being displayed as the macro
runs.
> > Thanks for any help
> > Ben