Macro Toolbar

S

sue t

Hello:
I use Excel 2003 in XP
I can't get the macro toolbar to become visible when I am
recording a macro. I have right clicked on the top and
cannot find the toolbar in the list. I want to use the
option on this toolbar to set the range as relative
instead of absolute. If I cannot get this toolbar to
appear is there another way to set that? I am just
starting out in the VBA Editor so am not quite sure what
line or command to take out to achieve this. Thank You
for Your Help
 
B

Bernie Deitrick

Sue,

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
 
S

sue t

It works, thank you I know if I come to this group I can
always get the help I need!!
 
Top