unhide worksheets

[gss]

I am working in a spreadsheet that was created by someone else, and using macros, he used different worksheets (that he went on to hide) to compute formulas and store data.

My question is: how do I access those hidden worksheets to review the formulas and calculations?

Thanks for the help!

[Richard Buttrey]

Hi,

Presumably you've tried unhiding them using the Format Sheet Unhide menu and can't see the sheets?

In which case go to the Visual Basic Environment (VBE) with ALT-F11. In the Project Explorer window on the left find the sheet in question and Select it. Now go dow to the Properties window, find the 'Visible' property and choose the xlSheetVisible option, Now close the VBE.

HTH

[Gayucvns]

Hi,

If you know the Hided Sheet Name you can Unhide those by going Format->Sheet->Unhide or you can even unhide by macro by using the following code..
Sheets("Sheet4").Visible = True

Thanks
Gayucvns

[gss]

That worked. Thanks.