MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to view hidden worksheets?

  Asked By: Qadriyah    Date: Jan 19    Category: MS Office    Views: 2017

I got a workbook from someone else, with a worksheet where a formula
uses a value from a hidden sheet.

If I go under the "Window" menu item, "Unhide..." is greyed out.
When I go into VBA, the VBA for the file is locked.

Is there any way to unhide or view this hidden sheet?



4 Answers Found

Answer #1    Answered By: Courtney Hughes     Answered On: Jan 19

The sheet  is presumably in "very hidden" mode. You can only unhide  this
from VBA. Get the VBA password from the person that gave you the password
or ask him/her to unhide the sheet for you.

The owner will have hidden  it for a reason. You need to get proper
permission / assistance to view  it.

Answer #2    Answered By: Hiroshi Yoshida     Answered On: Jan 19

Infortunately, I don't think we can get the password.
Is there some kind of hack to circumvent the password?

Answer #3    Answered By: Eustatius Bakker     Answered On: Jan 19

Open a new workbook. Paste the following code into a VBA module in it:

Public Sub UnhideAllSheets()
'Unhide all worksheets  in the active workbook.
Dim x As Integer
On Error GoTo UASerr
For x = 1 To Worksheets.Count
Sheets(x).Visible = True
Next x
Exit Sub
MsgBox "Error", , "UnhideAllSheets"
End Sub

Open the workbook  with the hidden  sheet. From the Tools menu, select Macro >>
Macros >> UnhideAllSheets >> Run.

Answer #4    Answered By: Ismet Yilmaz     Answered On: Jan 19

Thanks. That's a good one to know.

Didn't find what you were looking for? Find more on How to view hidden worksheets? Or get search suggestion and latest updates.