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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
You can "stop" the recording of a macro by doing Tools > Macro > StopRecording

Vaya con Dios,
Chuck, CABGx3
 
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
 
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

Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
Macro to change formula? 5
Locate data macro 2
#REF! in Excel Formula 1
Macro using a cell reference 3
Macros 1
Pasting cell contents into a macro 1
Help to create a macro 2

Back
Top