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

S

Steve K

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

Scroll does not show preview 0
migrate xls app 2003 to 2007 -- get custom macro button out of des 3
Need VBA to remove command buttons 4
Crash on Close from 2 stable Access forms after unsolicited install of VS 2015 0
relative reference pivot table macro 2
"Following Features Cannot be saved" error on LOADING ?? 1
[Excel 2010] fails to record macro for Custom Error Bars 0
How do you get Excel to record a macros using relative refernce mo 4

Top