Restore toolbars

  • Thread starter Thread starter Brenda
  • Start date Start date
B

Brenda

I've completely removed the toolbars with code and can't
figure out how to get them back.

Help!
TIA,
Brenda
 
Hi Brenda

Try this first

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

Alt-F11
Insert module from the menubar in the VBA editor
Paste the macro test in there
Alt-Q to go back to Excel

In Excel press Alt-F8 to get a macro list
Select it and press Run
 
Thanks Ron!
-----Original Message-----
Hi Brenda

Try this first

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

Alt-F11
Insert module from the menubar in the VBA editor
Paste the macro test in there
Alt-Q to go back to Excel

In Excel press Alt-F8 to get a macro list
Select it and press Run


--
Regards Ron de Bruin
(Win XP Pro SP-1 XL2000-2003)







.
Click to expand...
 
Back
Top