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