Macro Toolbar

  • Thread starter Thread starter sue t
  • Start date Start date
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
 
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
 
Back
Top