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!!