Problem upgrading to Excel 2007

[Stef]

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.

 

[Bob Phillips]

Why not just do a

Worksheets("Sheetname").Visible = xlSheetVisible

in the VBIDE immediate window

 

[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

 

[Don Guillett]

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

 

[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"

 

[Gord Dibben]

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

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


Gord Dibben MS Excel MVP

 

[Stef]

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]

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.