I have a VBA macro which is available through the Excel menubar.
This macro makes a new custum toolbar, opens a protected workbook with
differenst also protected sheets and hides most of the sheets depending on
the name of the sheet. When the workbook is closed, all sheets are visible
again and the workbook is saved.
The problem now is that every other time, the program does or doesn't hide
the sheets in the workbook.
What is happening?
many thanks

Possibly workbook level protection is getting toggled so every other time it
is off and you can manipulate the sheets and the other time it fails.

Just a guess, but I would think it is some condition that is getting
toggled.

--
Regards,
Tom Ogilvy

"Roland" wrote in message
...
I have a VBA macro which is available through the Excel menubar.
This macro makes a new custum toolbar, opens a protected workbook with
differenst also protected sheets and hides most of the sheets depending on
the name of the sheet. When the workbook is closed, all sheets are visible
again and the workbook is saved.
The problem now is that every other time, the program does or doesn't hide
the sheets in the workbook.
What is happening?
many thanks