B Brenda Dec 17, 2003 #1 I've completely removed the toolbars with code and can't figure out how to get them back. Help! TIA, 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 Dec 17, 2003 #2 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
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 Dec 18, 2003 #3 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...
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...
