Hidden worksheet problem

[robot]

Hello,

I have a workbook in which one worksheet is hidden. (I know that because
some formulae refer to values of cells in a worksheet that cannot be seen.)

However, when I tried unhiding the worksheet by clicking format --
worksheet, both the "hiding worksheet" and "unhiding worksheet" menu items
are dimmed. What else can I do to unhide the worksheet?

 

[Frank Kabel]

Hi
could be that this sheet was hidden with VBA (using xlsheetveryhidden).
Try the following code in VBA
sub unhide_all()
dim wks as worksheet
for each wks in worksheets
wks.visible=true
next
end sub

 

[Joe Fawcett]

Hello,

I have a workbook in which one worksheet is hidden. (I know that because
some formulae refer to values of cells in a worksheet that cannot be seen.)

However, when I tried unhiding the worksheet by clicking format --
worksheet, both the "hiding worksheet" and "unhiding worksheet" menu items
are dimmed. What else can I do to unhide the worksheet?

Perhaps the sheet is "very hidden" (this means hidden by code)
Open the VBA editor (ALT+F11)
Open immediate window (Ctr+G)
Enter:
?WorkSheets("Sheet3").visible
and press return.
using the name of the sheet instead of sheet3 if necessary.
If the answer is 2 then sheet is "Very Hidden"
Enter:
Worksheets("Sheet3").Visible = true
and press return