Command bar Defaults

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)
 
Back
Top