MrExcel Publishing
Your One Stop for Excel Tips & Solutions


Posted by Dave LaFrankie on April 16, 2001 6:38 AM

A couple of years ago I was sent a spreadsheet that worked great. Apparently it is a selection sheet of sorts that uses data from two other spreadsheets to select product and pricing inofrmation.

Problem is that I need to change the data on the "two other" spreadsheets that are referneced in the first sheet but I can't see them anywhere. It appears they are contained within the workbook but the spreadsheet tabs do not show up. So I right clicked on the main sheet and clciked view code and under Project Explorer it shows the three sheets but the two that I need to change won't let me view them.

Is there a trick to this or am I just out of luck and will have to recreate this whole application?

Posted by Anon on April 16, 2001 6:45 AM

On the menu bar try going to Format/Sheet/Unhide..

Posted by Dave Hawley on April 16, 2001 6:51 AM

Hi Dave

If you can't unhide them from Format>Sheet>Unhide then they probably have their visible property set to xlVeryHidden. Try running this code:

Sub UnHideAllSheets()
'Written by OzGrid Business Applications
'Unhides all worksheets

Dim Wsht As Worksheet

For Each Wsht In ThisWorkbook.Worksheets
Wsht.Visible = xlSheetVisible
Next Wsht

End Sub


OzGrid Business Applications

Posted by steve on April 16, 2001 6:54 AM

Have you clicked the sheet tabs box under tool-options. Also is your spread sheet protected or is the sheet hidden. If you don't know the password they make password crackers or removers.
Let me know if thats the problem and I can help you remove that password.(only passwords that protect sheets or the workbook, I can't remove VBa password)
Let me know if this is the problem and I can help.