Working with Hidden worksheets

[Guest]

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"?

 

[Bob Phillips]

Application.ScreenUpdating = False

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

--

HTH

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