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
------------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...fo&userid=9930
View this thread: http://www.excelforum.com/showthread...hreadid=557056

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


--
halem2
------------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...fo&userid=9930
View this thread: http://www.excelforum.com/showthread...hreadid=557056

"halem2" wrote in
message ...

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.