ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How can I enable the "Record Using Relative References" option in. (https://www.excelbanter.com/excel-discussion-misc-queries/10777-how-can-i-enable-%22record-using-relative-references%22-option.html)

cbaugher

How can I enable the "Record Using Relative References" option in.
 
When I try to record a macro I am not given th option to use relative
references. The manual suggests that I should have that option. Is there a
setting somwhere that might enable this feature? Thankyou
--
Chris

JulieD

Hi

when you start recording a macro (after pressing OK) you should have a
toolbar with two icons - the stop recording icon and the relative reference
icon - if you can't see it, once you've pressed OK choose view / toolbars /
stop recording and it will come back again. To change from absolute to
relative recording the relative recording icon needs to be indented.

Cheers
JulieD

"cbaugher" wrote in message
...
When I try to record a macro I am not given th option to use relative
references. The manual suggests that I should have that option. Is there a
setting somwhere that might enable this feature? Thankyou
--
Chris





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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com