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

If your interested!!!!!!

--
Regards,
Tom Ogilvy



"Ben" wrote in message
...
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