CAN'T VIEW MS EXCEL OBJECTS
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
'www.ozgrid.com
'Unhides all worksheets
Dim Wsht As Worksheet
For Each Wsht In ThisWorkbook.Worksheets
Wsht.Visible = xlSheetVisible
Next Wsht
End Sub
Dave
OzGrid Business Applications
Posted by steve on April 16, 2001 6:54 AM
steve
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.
steve
