Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can you change excel macros from absolute to relative?
These are NOT formulas ok? I want to do the same change to a variety of
different rows/columns in the form of a macro I can run via control key combo shortcut. How can I do this so that the default macro is not absolute and in fact only performs the keystroke steps I want the macro to record? Can anyone help me here??? Thanks for your efforts! :) |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can you change excel macros from absolute to relative?
Hi
When you invoke the macro recorder, click on the icon to the right of the stop button before any of your keystrokes to switch to Relative addressing. -- Regards Roger Govier "Ralonne" wrote in message ... These are NOT formulas ok? I want to do the same change to a variety of different rows/columns in the form of a macro I can run via control key combo shortcut. How can I do this so that the default macro is not absolute and in fact only performs the keystroke steps I want the macro to record? Can anyone help me here??? Thanks for your efforts! :) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can you change excel macros from absolute to relative?
Thank you for your response. However, how does one switch to relative
addressing? I THOUGHT I knew Excel but maybe not as well as I imagined lol! "Roger Govier" wrote: Hi When you invoke the macro recorder, click on the icon to the right of the stop button before any of your keystrokes to switch to Relative addressing. -- Regards Roger Govier "Ralonne" wrote in message ... These are NOT formulas ok? I want to do the same change to a variety of different rows/columns in the form of a macro I can run via control key combo shortcut. How can I do this so that the default macro is not absolute and in fact only performs the keystroke steps I want the macro to record? Can anyone help me here??? Thanks for your efforts! :) |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can you change excel macros from absolute to relative?
Hi
When you choose ToolsMacroRecord New Macro after the clicking OK to the dialogue box offering you the chance to name the macro, you should get a small floating Toolbar with the Stop Recording button and a small graphic to the right of this. Clicking the small graphic to the right of the Stop button toggles Absolute to Relative referencing. Sometimes, this toolbar can disappear if you have stopped the macro recording in another manner. To re-invoke it, choose ToolsMacroRecord New Macro Move the cursor over a toolbar and RIGHT click, then select STOP RECORDING from the pop-up that appears, and the tool bar will show itself . Click the Stop recording button .. The Floating Toolbar should now re-appear when you try to record another macro, enabling you to select your Relative addressing. -- Regards Roger Govier "Ralonne" wrote in message ... Thank you for your response. However, how does one switch to relative addressing? I THOUGHT I knew Excel but maybe not as well as I imagined lol! "Roger Govier" wrote: Hi When you invoke the macro recorder, click on the icon to the right of the stop button before any of your keystrokes to switch to Relative addressing. -- Regards Roger Govier "Ralonne" wrote in message ... These are NOT formulas ok? I want to do the same change to a variety of different rows/columns in the form of a macro I can run via control key combo shortcut. How can I do this so that the default macro is not absolute and in fact only performs the keystroke steps I want the macro to record? Can anyone help me here??? Thanks for your efforts! :) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can you change excel macros from absolute to relative?
You can try this EnergyKey
http://www30.webSamba.com/SmartStudio This may be help you. Now I always use EnergyKey, it helps me so much in my work. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How can you change excel macros from absolute to relative?
Thank you SOOO much - that's EXACTLY what I wanted to know, Roger! Your
assistance is invaluable, thank you! Ralonne "Roger Govier" wrote: Hi When you choose ToolsMacroRecord New Macro after the clicking OK to the dialogue box offering you the chance to name the macro, you should get a small floating Toolbar with the Stop Recording button and a small graphic to the right of this. Clicking the small graphic to the right of the Stop button toggles Absolute to Relative referencing. Sometimes, this toolbar can disappear if you have stopped the macro recording in another manner. To re-invoke it, choose ToolsMacroRecord New Macro Move the cursor over a toolbar and RIGHT click, then select STOP RECORDING from the pop-up that appears, and the tool bar will show itself . Click the Stop recording button .. The Floating Toolbar should now re-appear when you try to record another macro, enabling you to select your Relative addressing. -- Regards Roger Govier "Ralonne" wrote in message ... Thank you for your response. However, how does one switch to relative addressing? I THOUGHT I knew Excel but maybe not as well as I imagined lol! "Roger Govier" wrote: Hi When you invoke the macro recorder, click on the icon to the right of the stop button before any of your keystrokes to switch to Relative addressing. -- Regards Roger Govier "Ralonne" wrote in message ... These are NOT formulas ok? I want to do the same change to a variety of different rows/columns in the form of a macro I can run via control key combo shortcut. How can I do this so that the default macro is not absolute and in fact only performs the keystroke steps I want the macro to record? Can anyone help me here??? Thanks for your efforts! :) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel | |||
Stop excel from dropping the 0 in the beginning of a number? | Setting up and Configuration of Excel | |||
Excel crashes while opening excel file imbeddied with macros | Excel Discussion (Misc queries) | |||
Excel 97 macros to Excel 2003 | Excel Worksheet Functions | |||
How to change the color of all series in an excel chart in one go. | Charts and Charting in Excel |