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
|