MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Changing macro's to reflect hidden sheets


Posted by RANDY B on November 08, 2001 1:17 PM

Along the way I have recorded and written some macro's that refrence a couple of sheets that I wish to hide.
I have cells on the non hidden sheets that = the hidden sheet. The macro's are using advanced filter, pivot tables, and clearcontents. What is the genralized format for referencing hidden pages?


Posted by Tom Urtis on November 08, 2001 2:26 PM

Without knowing your specific circumstance, the general way to attack this is to unhide the hidden sheet, run your macro that refers to the hidden sheet, and re-hide that sheet, as such:

Worksheets("Sheet1").Visible = True
'YOUR MACRO
Worksheets("Sheet1").Visible = False

Tom Urtis

Posted by RANDY B on November 09, 2001 11:09 AM

THAT WORKS NICELY....THANKS (NT)