how to make Hidden sheet visible

[Herman]

I have an excel workbook from a former employee which when you start the xls it performs a macro to make an extra menu
the menu is being build from a worksheet where all the info is like name of submenu's face id's, i know this caase he told me that before he left.now i must change the menu so i thougt to change the sheet but i can't find it anywhere not when i use unhide .
when i use the vba editor there is a workbook with two sheets for example a sheet called menu and a sheet called info but neither one of them is visible in my workbook.

who can help me with this problem?

 

[Mark W.]

Look under the Format | Sheet menu command to see if Unhide isn't "ghosted".

 

[Herman]

No that's all normal.
in the vba editor i see there are 2 sheets but when i click on them , the view object button is greyed out and can't be chosen.
normally when you click on a sheet and select the view object button then the sheet is presented to you.

so i see 2 sheets in the vba editor but i can't see them anywhere.

 

[Ivan F Moala]

On 2002-03-01 12:05, Herman wrote:
No that's all normal.
in the vba editor i see there are 2 sheets but when i click on them , the view object button is greyed out and can't be chosen.
normally when you click on a sheet and select the view object button then the sheet is presented to you.

so i see 2 sheets in the vba editor but i can't see them anywhere.

Thats because the Sheets visible property is
set to Xlsheetveryhidden.
Goto the sheets properties F4
Scroll down until you see visible
Change this property here to xlsheetvisible


Ivan

 

[Herman]

That's when you have a normal xls
but this one is an xla(addin)
i know the password for the xla otherwise i couldn't see the vba code
but when i want to set the properties is xla to no then it asks me again for a password
and then the password i used to open the vba editor isn't good anymore.

sorry for not mentioning that it all goes about an xla file

 

[Mark O'Brien]

Have you tried just opening the .xla file?

*.xla's are usually found somewhere in the directory:<pre>
C:Program FilesMicrosoft OfficeOfficeLibrary</pre>

If you browse to this location or search for the xla in question, just double click on it and
open it up. So long as you know the password you should be able to do whatever you want to it.

_________________<font color = green> Mark O'Brien
This message was edited by Mark O'Brien on 2002-03-01 12:51

 

[Guest]

Yes i have opened the xla and can view the code but i can't still use the option isaddin
and set it to no, then it asks for a password
.

and when i can't do that then i can't take a look at the sheets in the workbook

i cansee al modules forms etc.. and i can change them but the only thing i can't is et the isaddin option to false then there is a messagebox and asks me for a password

 

[Herman]

Anybody has a clue about previous discussed problem

 

[GeorgeB]

I don't know if this will work in your case but try this.

Enter the following code in a standard module.
Run it from the VBE with the Immediate window open.
All the sheets in the workbook whether hidden or not will be listed in the Immediate window.
(If you already know the names skip this part)

Public Sub ListSheets()
Dim varsheet As Variant
For Each varsheet In Sheets
Debug.Print varsheet.Name
Next varsheet

End Sub


Enter the following code in the same module.
Replace SHEET NAME with the name of the sheet you want to unhide.
Run the code.
The “Very Hidden” sheet will appear.

Public Sub ShowSheet()
Application.Worksheets("SHEET NAME").Visible = xlSheetVisible

End Sub

Good luck
This message was edited by GeorgeB on 2002-03-03 07:25

 

[Herman]

This doesn't work it look likes the workbook in the xla is also password protected, i unprotect the xla because i know the password but
if i want to set the workbook to isaddin no then it asks again for a password, the original password for the xla doesn't work.

greetings herman