Command bar Defaults

[Guest]

I've used this code to hide toolbars and command bars
Sub hide(
Dim bar As CommandBa
For Each bar In Application.CommandBar
bar.Enabled = Fals
Nex
End Su

Sub show(
Dim bar As CommandBa
For Each bar In Application.CommandBar
bar.Enabled = Tru
Nex
End Su

Problem is when I restart excel now it defaults to the hidden status

Thanks for any ideas.

 

[Bob Phillips]

You could put the show macro into the workbook open event of Personal.xls,
this will then re-display it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)