View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
tony tony is offline
external usenet poster
 
Posts: 313
Default Help with Unhide content .xls 2000

Hey Mike

Thanks for the advice & time, much appreciated,
I tried out your advice, but there are no projects to select from, this
option is not available and everything is greyed out the same as on the tool
bar!
Cheers Tony


"Mike" wrote:

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