My Relative Recording Button Is Gone

[TANJA]

HEY,

I'M PRETTY NEW AT EXCEL ,I JUST LEARNED ABOUT MACROS, SO I'VE BEE
RECORDING MACROS AND FOR THE MOST PART IT'S WORKED FINE, THERE HAS BEE
THE ODD ONE I HAD TO DELET , WELL I DONT KNOW WHAT I DID BUT WHEN
TRIE TO RECORD A MACRO NOW I DONT GET THAT LITTLE TOOLBAR THAT LETS YO
STOP THE RECORDING AND CHOOSE THE RELATIVE MODE, AND I CANT FIGURE O
HOW TO GET THE TOOLBAR BACK....

OR IS THERE A NOTHER WAY THAT I CAN CHOOSE RELATIVE RECORDING???

THANK YOU SO MUCH

TANJ

 

[CLR]

My "Stop" toolbar comes and goes at will also.........dunno
why...........but you can get out of the recording mode by doing Tools >
Macro > Stop Recording...........and please don't use all CAP's........I
find them hard to read.......thanks,

Vaya con Dios,
Chuck, CABGx3

 

[Max]

Perhaps this previous advisory by Gord Dibben will help ..
--------
From: Gord Dibben ([email protected])
Subject: Re: Relative Reference choice missing from macro window
Newsgroups: microsoft.public.excel.programming
Date: 2001-01-15 14:00:09 PST

CometX

When you select Record New Macro does the Stop Recording Bar appear? Is the
Relative Reference button missing? If so, go to Tools>Customize and select
the Stop Recording check box and "Reset".

If the Stop Recording Bar does not appear at all, Tools>Customize select the
check box at Stop Recording. Close Customize dialog. You can now Close the
Stop recording bar. Next time you select Tools>Macros>Record Macro - Stop
Recording bar should pop up again. DO NOT CLOSE IT AGAIN USING THE X OR
YOU
WILL HAVE TO RE-ARM AGAIN. When you want to Stop Recording, just hit the
button with the blue dot.

HTH Gord

I've seen Excel that when you want to record a macro, you can click on "Use
Relative Reference". The PC that I was just assigned runs Excel 97, but the
choice is not there. Is there a switch I can turn on?