View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike Mike is offline
external usenet poster
 
Posts: 3,101
Default Help with Unhide content .xls 2000

This doesn't sound good!!

If the unhide button is greyed out then it is because the there are no
hidden worksheets or the sheet is very hidden using VBA.

Paste this module to count your worksheets to establish if it is there or not

Sub test()
x = Worksheets.Count
MsgBox (x)
End Sub

The essage box will return the number of sheets including any very hidden
ones. If it is very hidden then

Worksheets("Sheet2").Visible = True

Will make it visible again

Mike



"Tony" wrote:

I have created a worksheet in .xls 2000 that appears to have gone into the
hide mode? but with one important Malfunction, when I open the file the
unhide button on the tool bar is not accessible?
Is there anyway around this so as to gain full access to the data therein
again?

Cheers Tony