|
Absolute or Relative reference - no longer a choice!
When I used to click-on or select the record macro button, a small icon used to pop-up that allowed me to select whether I wanted absolute or relative reference. For some reason, the icon does not display anymore, and I don't know how to record a macro in relative; it automatically records in absolute. I needed a macro to work using the two cells next to wherever the cursor was placed, and I ended up having to edit the recorded macro by replacing the absolute cell references with "-with selection-" and "-end with-". This worked, even if it is not the proper way to get relative reference. How can I (again) choose whether a macro is recorded using relative or absolute reference? Thanks! Alex -- Ingeniero1 ------------------------------------------------------------------------ Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029 View this thread: http://www.excelforum.com/showthread...hreadid=510161 |
Absolute or Relative reference - no longer a choice!
Click on Tools - Customize - Toolbars and Check Stop Recording. The tool
bar you are refering to should pop up. Now record a macro, and click stop (not close) on the stop recording menu. The menu should disappear. It will now come back in the future... -- HTH... Jim Thomlinson "Ingeniero1" wrote: When I used to click-on or select the record macro button, a small icon used to pop-up that allowed me to select whether I wanted absolute or relative reference. For some reason, the icon does not display anymore, and I don't know how to record a macro in relative; it automatically records in absolute. I needed a macro to work using the two cells next to wherever the cursor was placed, and I ended up having to edit the recorded macro by replacing the absolute cell references with "-with selection-" and "-end with-". This worked, even if it is not the proper way to get relative reference. How can I (again) choose whether a macro is recorded using relative or absolute reference? Thanks! Alex -- Ingeniero1 ------------------------------------------------------------------------ Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029 View this thread: http://www.excelforum.com/showthread...hreadid=510161 |
Absolute or Relative reference - no longer a choice!
Are you sure that works... Using the X closes the toolbar and keeps it from
re-apperaing. I don't use this menu but as memory serves I believe that using the X is how Ingeniero1 would have gotten into this problem in the first place. Unless I am missing something... -- HTH... Jim Thomlinson "Gary L Brown" wrote: Open up the toolbar... ToolsCustomizeToolbars Select 'Stop Recording' Close the 'Stop Recording' button by 'x'ing out of it. It should re-appear from now on. or run this macro called TryMe... '/======================================/ Public Sub TryMe() Application.CommandBars("Stop Recording").Visible = True End Sub '/======================================/ and then close the 'Stop Recording' button by 'x'ing out of it. It should re-appear from now on. HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Ingeniero1" wrote: When I used to click-on or select the record macro button, a small icon used to pop-up that allowed me to select whether I wanted absolute or relative reference. For some reason, the icon does not display anymore, and I don't know how to record a macro in relative; it automatically records in absolute. I needed a macro to work using the two cells next to wherever the cursor was placed, and I ended up having to edit the recorded macro by replacing the absolute cell references with "-with selection-" and "-end with-". This worked, even if it is not the proper way to get relative reference. How can I (again) choose whether a macro is recorded using relative or absolute reference? Thanks! Alex -- Ingeniero1 ------------------------------------------------------------------------ Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029 View this thread: http://www.excelforum.com/showthread...hreadid=510161 |
Absolute or Relative reference - no longer a choice!
You're right! My apologies.
Thanks for the clearification. -- Gary Brown "Jim Thomlinson" wrote: Are you sure that works... Using the X closes the toolbar and keeps it from re-apperaing. I don't use this menu but as memory serves I believe that using the X is how Ingeniero1 would have gotten into this problem in the first place. Unless I am missing something... -- HTH... Jim Thomlinson "Gary L Brown" wrote: Open up the toolbar... ToolsCustomizeToolbars Select 'Stop Recording' Close the 'Stop Recording' button by 'x'ing out of it. It should re-appear from now on. or run this macro called TryMe... '/======================================/ Public Sub TryMe() Application.CommandBars("Stop Recording").Visible = True End Sub '/======================================/ and then close the 'Stop Recording' button by 'x'ing out of it. It should re-appear from now on. HTH, -- Gary Brown If this post was helpful, please click the ''Yes'' button next to ''Was this Post Helpfull to you?''. "Ingeniero1" wrote: When I used to click-on or select the record macro button, a small icon used to pop-up that allowed me to select whether I wanted absolute or relative reference. For some reason, the icon does not display anymore, and I don't know how to record a macro in relative; it automatically records in absolute. I needed a macro to work using the two cells next to wherever the cursor was placed, and I ended up having to edit the recorded macro by replacing the absolute cell references with "-with selection-" and "-end with-". This worked, even if it is not the proper way to get relative reference. How can I (again) choose whether a macro is recorded using relative or absolute reference? Thanks! Alex -- Ingeniero1 ------------------------------------------------------------------------ Ingeniero1's Profile: http://www.excelforum.com/member.php...fo&userid=4029 View this thread: http://www.excelforum.com/showthread...hreadid=510161 |
Absolute or Relative reference - no longer a choice!
Jim, This, "-Click on Tools - Customize - Toolbars and Check Stop Recording. Th tool bar you are refering to should pop up. Now record a macro, and clic stop (not close) on the stop recording menu. The menu should disappear. I will now come back in the future...-" worked fine - Thank you! Ale -- Ingeniero ----------------------------------------------------------------------- Ingeniero1's Profile: http://www.excelforum.com/member.php...nfo&userid=402 View this thread: http://www.excelforum.com/showthread.php?threadid=51016 |
| All times are GMT +1. The time now is 06:57 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com