Frank said:
i seem to have deleted the excel macro icon that has the
stop button and the relative reference button. I don't
know how to get them back.
Perhaps this previous post 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