Macro recorder dialog box

  • Thread starter Thread starter Laurie
  • Start date Start date
L

Laurie

I was recording a Macro and I accidently hit the "x" and
closed the recorder dialog box. I stoped recording (from
the menu), deleted the Macro and attempted to start
recoding it again. When I select "Record Macro" I no
longer get the "Recording Macro" box. I can see that I
am recording by looking at the status bar. I have not
figured out how to make this box re-appear. Does anybody
have any suggestions? I am very frustrated!

THANKS!
 
Laurie, view, toolbars, stop recording.

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 
Paul, thanks for your quick response!

I know how to stop recording. My question is that I
cannot get the dialog box to re-appear when I go to use
the record macro function again. I have to keep going to
the toolbar to stop recirding. I need the option of
absolute or relative reference and I cannot get that from
the toolbar.

Thanks
Laurie
 
Record a macro, then while recording do view>toolbars, check the stop
recording toolbar,
stop the recording but DO NOT click the X to close the stop recording
toolbar.
Delete the macro, next time you record a macro it will pop up
 
Peo:

My point is that I DID hit the X (by accident) to close
the stop recording toolbar (I think that is what I am
calling the macro recording dialog box). Now, no matter
what I do, the box (recording toolbar) does not re-appear.

Thanks,
Laurie
 
Laurie

Try Tools>Customize>Toolbars. Scroll down to "Stop Recording" and checkmark
it. Should become visible on the sheet.

Record some throwaway macro and make sure you use the "Stop Recording" button.

You already know what happens when you hit the "X".

Gord Dibben Excel MVP
 
Thanks a bunch - that worked!

Laurie
-----Original Message-----
Laurie

Try Tools>Customize>Toolbars. Scroll down to "Stop Recording" and checkmark
it. Should become visible on the sheet.

Record some throwaway macro and make sure you use the "Stop Recording" button.

You already know what happens when you hit the "X".

Gord Dibben Excel MVP



.
Click to expand...
 
Your date is a bit off. Surely, not on purpose.

--
Don Guillett
SalesAid Software
(e-mail address removed)
Vasant Nanavati said:
LOL! She obviously understands Canadian!
Click to expand...
 
Thanks, Don. No idea how that happened. I sometimes open the Date/Time
dialog to use it as a visual calendar and must have hit the wrong button
when I exited out of it.

Regards,

Vasant.

Don Guillett said:
Your date is a bit off. Surely, not on purpose.
Click to expand...
 

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

Access Automatically Send a notification email once a record is added 0
Macro 1
Use the custom filter dialog in a macro 3
Can I record a macro on a cell that has text but not a text box 2
Macro to delete any control box and pictures 2
Macro To Make Workbook Demonstrate Itself 2
Protect Sheet Macro 1
How do I make the Stop Recording bar pop up when recording macros 1

Back
Top