splash screen.....

[Lee Taylor-Vaughan]

Hi all,

On my forms load, or open event i want it to loop through all the toolbars &
menubars and assign them not to show... (its a splash screen).
could someone help me with the code on how to do this, please.

thanks in advance...


lee

 

[Stephane]

Hi Lee,

Try...


Dim ComBar As CommandBar

For Each ComBar In Application.CommandBars
ComBar.Enabled = True
Next ComBar

Steph

 

[Stephane]

ComBar.Enabled = True to show them and

ComBar.Enabled = False to hide them

Steph