Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Relative Cell position NOT working with or without macro | Excel Discussion (Misc queries) | |||
Change result of Macro Recorder | Excel Discussion (Misc queries) | |||
Relative Macro Help on Keystrokes | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) | |||
Record Macro Relative does not work? | Excel Discussion (Misc queries) |