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

V

Vinod Lala

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.
 
C

CLR

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

Vaya con Dios,
Chuck, CABGx3
 
M

Michael

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
 
V

Vinod Lala

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
 
Top