I cannot record a macro in relative mode. The button never shows.

G

Guest

I am using Excel 2002 SP3.
I am trying to record a macro in relative mode but when I start to record I
do not get the two button toolbar (stop and relative mode). The status bar
shows I am in record mode but I cannot figure out how to get into relative
mode. All of the other version of Excel I have used gave me the button when I
started recording.

Is there a setting I need to change?
 
G

Gord Dibben

Tools>Customize>Toolbars.

Select the Stop Recording Toolbar.

Start Recording a macro then hit the Stop button.

DO NOT hit the "x" to stop or you will lose the Toolbar again.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Relative Reference in a Macro 2
relative reference pivot table macro 2
How do I set up a macro using relative cell reference? 1
Disabled Absolute/Relative Macro Button 4
relative reference button on end macro menu 4
Can't find "stop recording" toolbar to use relative references 2
Macro- Relative reference 2
Show Record Macro Toolbar 2

Top