Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
ChasX
 
Posts: n/a
Default Macro Recorder-Relative relation

In the past I would use the macro recorder to record short macros in my work.
I was given the opportunity to choose relative relations for the macro. For
some reason the choice disappeared. How can I bring it back? I tried
repairing the installation from the CD. But no help.
Using Office XP in W98 SE.
Thankyou
  #2   Report Post  
Anne Troy
 
Posts: n/a
Default

Hi, Chas. Are you saying that when you go to record a macro, there's no
"Relative Reference" button on the Stop Recording toolbar?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"ChasX" wrote in message
...
In the past I would use the macro recorder to record short macros in my

work.
I was given the opportunity to choose relative relations for the macro.

For
some reason the choice disappeared. How can I bring it back? I tried
repairing the installation from the CD. But no help.
Using Office XP in W98 SE.
Thankyou



  #3   Report Post  
Hank Scorpio
 
Posts: n/a
Default

On Sat, 25 Jun 2005 21:30:01 -0700, "ChasX"
wrote:

In the past I would use the macro recorder to record short macros in my work.
I was given the opportunity to choose relative relations for the macro. For
some reason the choice disappeared. How can I bring it back? I tried
repairing the installation from the CD. But no help.
Using Office XP in W98 SE.
Thankyou


When you record a macro, a floating toolbar called "Stop Recording"
appears. This toolbar has the "Relative References" button on it. If
you close the toolbar while you're recording a macro, it won't appear
next time you record one either.

To bring it back, just record another macro. While the macro is
recording, right click in the toolbars area of your window, and select
the Stop Recording toolbar to make it visible again.

(Note that the toolbar is context sensitive, and won't appear in the
list of toolbars unless you're recording a macro.)

---------------------------------------------------------
Hank Scorpio
scorpionet who hates spam is at iprimus.com.au (You know what to do.)
* Please keep all replies in this Newsgroup. Thanks! *
  #4   Report Post  
ChasX
 
Posts: n/a
Default

Yes, there is no "Relative Reference" button on the stop recording toolbar.
I think Hank Scorpio answered this question in the following post , I will
try his suggedstion. Thank you for answering promptly , I appreciate as it
was an annoying problem.
chas

"Anne Troy" wrote:

Hi, Chas. Are you saying that when you go to record a macro, there's no
"Relative Reference" button on the Stop Recording toolbar?
*******************
~Anne Troy

www.OfficeArticles.com
www.MyExpertsOnline.com


"ChasX" wrote in message
...
In the past I would use the macro recorder to record short macros in my

work.
I was given the opportunity to choose relative relations for the macro.

For
some reason the choice disappeared. How can I bring it back? I tried
repairing the installation from the CD. But no help.
Using Office XP in W98 SE.
Thankyou




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Relative Cell position NOT working with or without macro Scratching my Head Excel Discussion (Misc queries) 6 May 30th 05 06:12 PM
Change result of Macro Recorder Jim May Excel Discussion (Misc queries) 3 May 21st 05 01:58 PM
Relative Macro Help on Keystrokes Neal Zimm Excel Discussion (Misc queries) 9 December 15th 04 12:31 AM
Record Macro Relative does not work? lbbss Excel Discussion (Misc queries) 3 December 13th 04 08:43 PM
Record Macro Relative does not work? lbbss Excel Discussion (Misc queries) 1 December 13th 04 07:55 PM


All times are GMT +1. The time now is 11:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"