Restore toolbars

B

Brenda

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

Help!
TIA,
Brenda
 
R

Ron de Bruin

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
 
B

Brenda

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