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

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