I just upgraded Excel from 2003 to 2007. I have a workbook that contains a
huge VBA-code. I have two hidden sheets in that workbook that I now can not
unhide, since the button is grayed and is not clicable. These sheets contain
tables that are being updated regulary. Any idea how I can recover these
sheets? I can see in the macrowindow that they are there.
--
Stef

Why not just do a

Worksheets("Sheetname").Visible = xlSheetVisible

in the VBIDE immediate window

--
__________________________________
HTH

Bob

"Stef" wrote in message
...
I just upgraded Excel from 2003 to 2007. I have a workbook that contains a
huge VBA-code. I have two hidden sheets in that workbook that I now can
not
unhide, since the button is grayed and is not clicable. These sheets
contain
tables that are being updated regulary. Any idea how I can recover these
sheets? I can see in the macrowindow that they are there.
--
Stef

Yes this worked, but when I try to hide one of the now visible sheets with
the "hide" button, all sheets are hidden. I just want to hide some of them
and leave some visible. I.e the way it worked with Excel 2003
--
Stef


"Bob Phillips" wrote:

Why not just do a

Worksheets("Sheetname").Visible = xlSheetVisible

in the VBIDE immediate window

--
__________________________________
HTH

Bob

"Stef" wrote in message
...
I just upgraded Excel from 2003 to 2007. I have a workbook that contains a
huge VBA-code. I have two hidden sheets in that workbook that I now can
not
unhide, since the button is grayed and is not clicable. These sheets
contain
tables that are being updated regulary. Any idea how I can recover these
sheets? I can see in the macrowindow that they are there.
--
Stef

Perhaps the "hide button" has code associated with it that you may care to
share

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stef" wrote in message
...
Yes this worked, but when I try to hide one of the now visible sheets with
the "hide" button, all sheets are hidden. I just want to hide some of them
and leave some visible. I.e the way it worked with Excel 2003
--
Stef


"Bob Phillips" wrote:

Why not just do a

Worksheets("Sheetname").Visible = xlSheetVisible

in the VBIDE immediate window

--
__________________________________
HTH

Bob

"Stef" wrote in message
...
I just upgraded Excel from 2003 to 2007. I have a workbook that contains
a
huge VBA-code. I have two hidden sheets in that workbook that I now can
not
unhide, since the button is grayed and is not clicable. These sheets
contain
tables that are being updated regulary. Any idea how I can recover
these
sheets? I can see in the macrowindow that they are there.
--
Stef

This I don't quite understand. Should it be a built in code? I have not
written any code to handle this. I mean the option in the toolbar "Show -
window" and "Hide"
--
Stef


"Don Guillett" wrote:

Perhaps the "hide button" has code associated with it that you may care to
share

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Stef" wrote in message
...
Yes this worked, but when I try to hide one of the now visible sheets with
the "hide" button, all sheets are hidden. I just want to hide some of them
and leave some visible. I.e the way it worked with Excel 2003
--
Stef


"Bob Phillips" wrote:

Why not just do a

Worksheets("Sheetname").Visible = xlSheetVisible

in the VBIDE immediate window

--
__________________________________
HTH

Bob

"Stef" wrote in message
...
I just upgraded Excel from 2003 to 2007. I have a workbook that contains
a
huge VBA-code. I have two hidden sheets in that workbook that I now can
not
unhide, since the button is grayed and is not clicable. These sheets
contain
tables that are being updated regulary. Any idea how I can recover
these
sheets? I can see in the macrowindow that they are there.
--
Stef

Just a thought but..............

Do you have multiple sheets selected when you "Hide"?


Gord Dibben MS Excel MVP

On Sat, 12 Jul 2008 12:13:00 -0700, Stef wrote:

This I don't quite understand. Should it be a built in code? I have not
written any code to handle this. I mean the option in the toolbar "Show -
window" and "Hide"

No. I also try to right clic the mouse and it hides the active window but
then I cannot make it visible again. I have to do this by the immediate
window.
--
Stef


"Gord Dibben" wrote:

Just a thought but..............

Do you have multiple sheets selected when you "Hide"?


Gord Dibben MS Excel MVP

On Sat, 12 Jul 2008 12:13:00 -0700, Stef wrote:

This I don't quite understand. Should it be a built in code? I have not
written any code to handle this. I mean the option in the toolbar "Show -
window" and "Hide"

I found out that I can hide one sheet at a time by clicking the right button
on the mouse. To make it visible again I right click the mouse again and
there is an option to open the sheet. I guess this is the only way to do this.
--
Stef


"Stef" wrote:

No. I also try to right clic the mouse and it hides the active window but
then I cannot make it visible again. I have to do this by the immediate
window.
--
Stef


"Gord Dibben" wrote:

Just a thought but..............

Do you have multiple sheets selected when you "Hide"?


Gord Dibben MS Excel MVP

On Sat, 12 Jul 2008 12:13:00 -0700, Stef wrote:

This I don't quite understand. Should it be a built in code? I have not
written any code to handle this. I mean the option in the toolbar "Show -
window" and "Hide"