MrExcel Publishing
Your One Stop for Excel Tips & Solutions

How to un-hide hidden sheets in old spreadsheets


Posted by Bjørn Arne Berge on July 18, 2001 4:40 PM

I have an old Excel spreadsheet with a lot of VBA code that uses information stored in hidden sheets. The problem is that my current version of Excel (Excel 97 SR-2) does not recognise that my old spreadsheet (last updated in 1998, I believe with Excel 4 or even earlier...) has a lot of hidden sheets.

In the VB-editor I can see the list of the sheets that are hidden, but I am unable to change the "hidden" property on the hidden sheets.

As mentioned above, when I go to Format->Sheet-> the "Unhide..." menu is greyed out - but I know that there are hidden sheets there.

I need help!! to:

- find a way to un-hide the hidden sheets
- if nothing else helps: Where can I download and install old versions of Excel?
- any other hints/tips to help me out!!

Thanks!


Posted by faster on July 19, 2001 7:40 AM

Sounds like your entire workbook si protected. Try
removing the protection.

Posted by Cory on July 19, 2001 7:53 AM

Bjorn,

I think you were in the right place, but looking at the wrong thing. In the VBE where the list of sheets are, change the Visible property to xlSheetVisible and you should be alright. I went through this once before...

Cory