Excel 2000, lost macro toolbar

B

Ben

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

Thanks
Ben
 
B

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
 
N

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
[email protected]
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Top