Hideen Worksheet

[halem2]

Hi:

I have a workbook that someone else created with several worksheets.
When I right click on the navigation keys for the tabs on the left
bottom corner, it displays one shee I do not see when I scroll to the
right and left of the sheet names. I think the creator of the
worksheet may have used VB to hide it.

It does not show under Windows\Unhide.

Is there a way using code to make that sheet visible? I have tried

Sheets.Visible = True

but it fails
thanks

 

[halem2]

hw stupid can I be!!! format\unhide sheet!!!!!

 

[ikr]

Hi:

I have a workbook that someone else created with several worksheets.
When I right click on the navigation keys for the tabs on the left
bottom corner, it displays one shee I do not see when I scroll to the
right and left of the sheet names. I think the creator of the
worksheet may have used VB to hide it.

It does not show under Windows\Unhide.

Is there a way using code to make that sheet visible? I have tried

Sheets.Visible = True

but it fails
thanks

From Excel's menu bar, is Format | Sheet | Unhide greyed out? If not, click
on it, and it will display a list of hidden sheets, which you can then
unhide, one at a time. Windows | Unhide will unhide hidden windows, not
worksheets.