Hidden sheets in Excel

[KeyserSoze]

I am designing an Excel workbook that uses VBA to do manipulations on sheets. I will have only one sheet visible while the other sheets that are used for data manipulation and reporting will be hidden.

Question: Will I have to temporarily unhide a sheet before I can modify it and then re-hide it or can I just leave the sheets hidden and run my code?

Thanks!

 

[PHV]

Why not simply use trial and error ?
Anyway, code may modify cells in hidden sheets.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[KeyserSoze]

"Why not simply use trial and error ?

Cuz I be lazee an' stoopid.

It worked. Thanks for your help.