RECORDING EXCEL MACRO

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

Guest

Hi,
In the past when I clicked on the button to start recording a macro, it used
to display a box that had the stop recording button and the relative
reference button. That no longer shows up. The only nuisance is that I
can't change the relative reference setting before I start recording. I can
stop recording with the menu.

Is there a way to get the box to show again -- or a way to change the
relative reference record method without the box and button?
Thanks,
Bill Gargan
 
With a new workbook.

Start recording a macro.
Tools|customize|toolbars tab
check "stop recording"

And don't use that X to close the toolbar ever again! <vbg>
 

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
Recording Macro's Mini Floating Toolbar 5
First Time Macro User--Stop Recording Toolbar 1
Access Automatically Send a notification email once a record is added 0
What happens to the Relative Refererence icon? 2
My excel macro recorder no longer shows up when recording macro 3
Stop 2007 from recording formulas with Relative Referencing 5
No macro recording dialog box 2

Back
Top