| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I cannot record a macro in relative mode. The button never shows.
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
I cannot record a macro in relative mode. The button never shows.
ToolsCustomizeToolbars.
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 On Tue, 16 Oct 2007 04:46:00 -0700, Steve K <Steve wrote: 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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to record macro with relative addressing in Excel 2000 | Excel Discussion (Misc queries) | |||
| How do I record a macro with relative cell addresses? | Excel Discussion (Misc queries) | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
| Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
| record macro - copy absolute, paste relative | Excel Programming | |||
Linear Mode
