Problem upgrading to Excel 2007

  • Thread starter Thread starter Stef
  • Start date Start date
S

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.
 
Why not just do a

Worksheets("Sheetname").Visible = xlSheetVisible

in the VBIDE immediate window
 
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
 
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"
 
Just a thought but..............

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


Gord Dibben MS Excel MVP
 
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.
 
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.
 
Back
Top