Hi Syn !! :)
It's done this way.


Sub abc()
Sheets("A").Select
Application.ScreenUpdating = False
'************YOUR CODE*************
End Sub

Regards, Vijay

"Syndrome" wrote:

I have four worksheets within a workbook named A,B,C,D. I have an auto_close
macro that runs three seperate macros that affects sheets B,C,D but I would
like the workbook to remain on sheet A whilst the macro is running.

Any help would be appreciated