Datasheet
Is the sheet is hidden forever? Nope. To make the very hidden sheet visible again, you use
a simple VBA macro. The macro listed here unhides Sheet2 of the active workbook (change
the sheet name as appropriate):
Sub UnhideSheet()
Worksheets(“Sheet2”).Visible = True
End Sub
CAUTION
Making a worksheet very hidden is not a security feature. Anyone who really wants to
know what resides on a very hidden sheet can easily find out by using the UnhideSheet
macro.
Tip 25: Making a Worksheet “Very Hidden”
65
Part I
04_137666 ch01.qxp 5/22/07 7:31 PM Page 65