Where can I find the relative reference icon to create a macro?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a macro on Excel 2003. I want the macro to run relative to the
position of the active cell so I need to select "relative reference", but the
relative reference box does NOT come up. Help shows that it is on the stop
recording toolbar, but I don't know where that toolbar is either. I started
the macro and stopped it, but "relative reference" is no where in my screen.
How can I find the icon?
 
Iliana

Tools>Customize>Toolbars. Select "Stop Recording" toolbar>Close

Stop Recording Toolbar should now be visible on sheet.

Hit "X" to close it(but not while you are recording).

It will pop up next time you use recorder. Do not close the "Stop
Recording" toolbar via "X" while recorder is running or you will lose it
again.

You can drag the "Relative Reference" button from the Visual Basic Toolbar to
any toolbar if you wish.

Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Record Macro Toolbar 1
How do I find "Stop Recording toolbar" of macros? 1
What happens to the Relative Refererence icon? 2
relative reference macro 1
Macro to extend formulas 4
Lost "Relative Reference" button in Excel 1
Macro - Relative Reference 2
Recording Macro's Mini Floating Toolbar 5

Back
Top