View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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