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

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

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

The Hide and unhide are on the windows menu.
If you don't use a buttom on the tool bar it will disappear. There is a
on the tool bar that shows the toolbar that weren't used. Selecting an used
one will bring it back to the active toolbar window.
Tool Bars can be added or deleted in the view toolbar. You can add
different toolbar depending on how youuse excel.

"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

Thanks Joel
But the hide & unhide button are there along with most other functions but
they are greyed out and unuseable.

Cheers Tony

"Joel" wrote:

The Hide and unhide are on the windows menu.
If you don't use a buttom on the tool bar it will disappear. There is a
on the tool bar that shows the toolbar that weren't used. Selecting an used
one will bring it back to the active toolbar window.
Tool Bars can be added or deleted in the view toolbar. You can add
different toolbar depending on how youuse excel.

"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

Tony

What do you see when you open the workbook?

Just a gray sheet?

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Or do you see a worksheet grid with no data?

Try WindowArrange


Gord Dibben MS Excel MVP

On Mon, 19 Feb 2007 03:30:13 -0800, 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

Hey Gord

Thanks for the advice & time, much appreciated,
All I see after opening the file is the grey sheet

The usual fix is not available as virtually all options on the tool bar are
greyed out.

I ran both (1) & (2) Start Run options and they appeared to do there thing,
but to no avail

I attempted the full path, but it would not run!

Are there any other options I can try?? Please

Cheers Tony



"Gord Dibben" wrote:

Tony

What do you see when you open the workbook?

Just a gray sheet?

Try the usual fix(es) for this problem.

ToolsOptionsGeneral uncheck "Ignore other Applications"
Exit Excel and try again

If this doesn't work try to re-register Excel

Close Excel first and On the Windows Taskbar

1) StartRun "excel.exe /unregserver"(no quotes)OK.
2) StartRun "excel.exe /regserver"(no quotes)OK.
See the space between exe and /regserver

You might have to designate a full path to excel.exe.
In that case StartRun "C:\yourpath\excel.exe /regserver"(no quotes)OK.


Or do you see a worksheet grid with no data?

Try WindowArrange


Gord Dibben MS Excel MVP

On Mon, 19 Feb 2007 03:30:13 -0800, 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