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)

"Lawlera" wrote in message
...
I've used this code to hide toolbars and command bars:
Sub hide()
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = False
Next
End Sub

Sub show()
Dim bar As CommandBar
For Each bar In Application.CommandBars
bar.Enabled = True
Next
End Sub

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

Thanks for any ideas.