Working with Hidden worksheets
 

I have a workbook with six detail worksheets and a couple of "menu"
worksheets. I am looking for a way to run several macros against the detail
sheets without having the user watch them flash by and change during the
macro's execution.

Is there a command that I can place in the macro to keep the worksheets
hidden but still use commands like "ActiveCell"?

Working with Hidden worksheets
 

Application.ScreenUpdating = False

at the start, and reset to True at the end.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Hibbs" wrote in message
...
I have a workbook with six detail worksheets and a couple of "menu"
worksheets. I am looking for a way to run several macros against the
detail
sheets without having the user watch them flash by and change during the
macro's execution.

Is there a command that I can place in the macro to keep the worksheets
hidden but still use commands like "ActiveCell"?