Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

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!


Re: How to un-hide hidden sheets in old spreadsheets

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

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


Re: How to un-hide hidden sheets in old spreadsheets

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


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.