Excel 2000, lost macro toolbar

[Ben]

Excel 2000: The macro tolbar that normally pops up when
you click "Record new macro" disappeared.
How do I restore it ?

Thanks
Ben

 

[Bernie Deitrick]

Ben

Run this little macro.

Sub MakeToolbarVisible()
With Application.CommandBars("Stop Recording")
.Visible = True
.Enabled = True
End With
End Sub

Remember to never close that toolbar by using the "X" at the upper right,
and it will continue to auto-hide and auto-show.

HTH,
Bernie
MS Excel MVP

 

[Norman Harker]

Hi Ben!

Start recording a macro
View > Toolbars
Select "Stop Recording" toolbar.
It will now appear on the screen and will disappear when you stop
recording.

It will now toggle on when you record next time.

Don't close the Stop Recording toolbar while recording or you'll lose
it again.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.