Can't find cell ref. when recording a macro in excel

G

Guest

When recordinng a macro in excel, I cant find the 'stop' recording button or
the cell ref. button in the dialog box wihich opens when I start recording.
 
G

Guest

You can "stop" the recording of a macro by doing Tools > Macro > StopRecording

Vaya con Dios,
Chuck, CABGx3
 
G

Guest

Vinod, at some point you must have closed the "stop recording" button when
recording a macro. To get it back, start recording a macro, any macro, and
then right click a tool bar and select Stop Recording. The button will show
up again. Do not click on the x as this will close the button again. HTH
 
G

Guest

Dear Michael,

Indeed, that was so helpful. However, the main purpose of getting this
dialog box back was to be able to choose relative cell ref. Is there any
other way to toggle the cell ref. from absolute to relative?

Best regards

VINOD LALA
 

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

First Time Macro User--Stop Recording Toolbar 1
Display Macro Recording Tool Bar 1
Macros 1
How do I get the Stop Recording toolbar to show on the worksheet? 3
macro - stop recording icon 3
How do I get the Stop Recording toolbar to show on the worksheet? 1
Recording new Macro won't reset drop downs 3
RECORDING EXCEL MACRO 2

Top