XL97 - Command Bar Removal
 

Dear All

Has anyone got a snipet of code that remembers which
CommandBars were visible on open so that on exit they can
be switched back on.

I can do all or nothing at the moment

Thanks in advance

Trevor

XL97 - Command Bar Removal
 

Hi Trevor

Use the Enabled property instead of the Visible

Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = False
Next

To get them back use this

Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = True
Next

--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)
www.rondebruin.nl



"Trevor Williams" wrote in message ...
Dear All

Has anyone got a snipet of code that remembers which
CommandBars were visible on open so that on exit they can
be switched back on.

I can do all or nothing at the moment

Thanks in advance

Trevor