Stop recording toolbar persistently missing

[ocookson]

Hi, hope someone can help.
When recording macros in Excel my Stop Recording Button doesn't appear
This is a pain because I can't switch to relative references. I've foun
several posts about the same problem, but the solutions mentioned ther
aren't working for me.
What I've tried:
1) Start recording macro, go to View, Toolbars, Click Stop Recording
Apparently the toolbar should then pop up, but on mine it doesn't. Th
Stop Recording option is already ticked when I enter the menu.
2) Tools, Customize, Toolbars, tick Stop Recording. Again, this has n
effect, and when I try it while recording a macro, it is alread
ticked.

Anyone know what's going on

 

[Guest]

First, I would look around the edges of my screen very closely. It might be
docked to one of the sides (like the Standard and Formatting toolbars are
usally docked at the top). It might be easy to miss since it is so small.
Don't Click the "x" t close it. Use the Stop Recording Button.


tj

 

[Jim Rech]

Running this macro should make this toolbar visible:

Sub a()
With CommandBars("Stop Recording")
.Visible = True
.Top = Application.Top * 1.5
.Left = Application.Left * 1.5
End With
End Sub

--
Jim Rech
Excel MVP
|
| Hi, hope someone can help.
| When recording macros in Excel my Stop Recording Button doesn't appear.
| This is a pain because I can't switch to relative references. I've found
| several posts about the same problem, but the solutions mentioned there
| aren't working for me.
| What I've tried:
| 1) Start recording macro, go to View, Toolbars, Click Stop Recording.
| Apparently the toolbar should then pop up, but on mine it doesn't. The
| Stop Recording option is already ticked when I enter the menu.
| 2) Tools, Customize, Toolbars, tick Stop Recording. Again, this has no
| effect, and when I try it while recording a macro, it is already
| ticked.
|
| Anyone know what's going on?
|
|
| --
| ocookson
| ------------------------------------------------------------------------
| ocookson's Profile:
http://www.excelforum.com/member.php?action=getinfo&userid=16769
| View this thread: http://www.excelforum.com/showthread.php?threadid=319669
|

 

[ocookson]

Brilliant! That's worked a treat. Thanks a lot, Jim.