I cannot record a macro in relative mode. The button never shows.

's Computer Specifications

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?

's Computer Specifications

Tools>Customize>Toolbars.

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 (E-Mail Removed)>
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?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do I record a macro with relative cell addresses?	=?Utf-8?B?VG9ueSBJQQ==?=	Microsoft Excel Misc	1	28th Oct 2005 04:55 PM
Delete Button shows previous record before current record is delet	=?Utf-8?B?UmljaDEyMzQ=?=	Microsoft Access Forms	8	10th Oct 2005 01:15 PM
Record Macro Relative does not work?	lbbss	Microsoft Excel Misc	3	13th Dec 2004 08:43 PM
Record Macro Relative does not work?	lbbss	Microsoft Excel Misc	1	13th Dec 2004 07:55 PM
Macro relative to button position	wesandem	Microsoft Excel Programming	14	26th Jan 2004 03:08 AM