Restore toolbars
 

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

Help!
TIA,
Brenda

Restore toolbars
 

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)
www.rondebruin.nl



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

Help!
TIA,
Brenda

Restore toolbars
 

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)
www.rondebruin.nl



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

Help!
TIA,
Brenda


.