Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't find cell ref. when recording a macro in excel
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't find cell ref. when recording a macro in excel
You can "stop" the recording of a macro by doing Tools Macro StopRecording
Vaya con Dios, Chuck, CABGx3 "Vinod Lala" wrote: 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. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't find cell ref. when recording a macro in excel
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 -- Sincerely, Michael Colvin "Vinod Lala" wrote: 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. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can't find cell ref. when recording a macro in excel
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 "Michael" wrote: 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 -- Sincerely, Michael Colvin "Vinod Lala" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Row Expansion | Excel Worksheet Functions | |||
Recording new excel macro, relative reference button doesn't show | New Users to Excel | |||
Find the cell value in excel by using vb code | Excel Discussion (Misc queries) | |||
macro to Find Replace in Excel | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |