ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do I change macro relative reference? no stop recording tool (https://www.excelbanter.com/excel-discussion-misc-queries/118445-how-do-i-change-macro-relative-reference-no-stop-recording-tool.html)

G

how do I change macro relative reference? no stop recording tool
 
When I try to get rid of "relative reference" in a Macro, I cant get back to
choose relative reference and not relative reference. Macos all stay in
relative reference.

Gord Dibben

how do I change macro relative reference? no stop recording tool
 
ToolsCustomizeToolbars.

Select the Stop Recording Toolbar.

Start Recording a macro then hit the Stop button.

DO NOT hit the "x" to stop or you will lose the Toolbar again.


Gord Dibben MS Excel MVP




On Sat, 11 Nov 2006 10:43:01 -0800, G wrote:

When I try to get rid of "relative reference" in a Macro, I cant get back to
choose relative reference and not relative reference. Macos all stay in
relative reference.


Gord Dibben MS Excel MVP


All times are GMT +1. The time now is 05:00 AM.

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