Turning off all Excel 2000 toolbars ? 2

[vamoose]

I know this will work for each individual toolbar:

Application.CommandBars("Visual Basic").Visible = False

But can all toolbars be turned off without specifically calling out each one ?

Thanks.

 

[SkipVought]

Hi,

Check out the ToolBars Collection. You cannot turn ALL the toolbars off.

Skip,

_{[red]Be Advised![/red] A chicken, who would drag a wagon across the road for 2 cents, is…
POULTRY in motion to PULLET for a PALTRY amount!}

 

[rmikesmith]

Try something like:

Dim CBar As CommandBar

   For Each CBar In Application.CommandBars
     With CBar
       If (.Type <> msoBarTypeMenuBar) And .Visible Then
         .Visible = False
       End if
     End With
   Next CBar

The test for the Type property is because you cannot hide the Menubar (although you could substitute a custom Menubar)


Regards,
Mike