Launching Macro Recorder using VBA

**paulzak** · 06-09-2009, 03:50 PM

I hide all Excel standard tabs and thus need a button on custom tab to record a macro. (I did this successfully with custom menu in Excel 2003.) In 2007 ribbon, I've reused the code for a button's OnAction, now going to callback that runs:

Application.CommandBars.ExecuteMso ("MacroRecord")

In Excel 2003, the stop button appeared automatically for me. But in Excel 2007, with hiding standard tabs, etc., I see no way to stop recording, other than running my button to return the Developer's tab, where the Record Macro button has changed to Stop Macro.

I'd like to either add a second button to my ribbon to stop recording the macro (but I can't find an idMso to use in a callback) or have my Record button change to Stop button, like Excel does. But I can't come up with correct code.

Has anyone added a custom Ribbon button for record macro successfully and would share how? Or does someone know the VBA to stop the recorder?

**Leith Ross** · 06-09-2009, 09:00 PM

Hello paulzak,

Here is the code to launch the Macro Recorder.

Please Login or Register  to view this content.

**paulzak** · 06-11-2009, 10:54 AM

Leith,

Thanks for the reply but this code runs like my prior code posted above. Your code starts the recorder but I still do NOT have a way to *stop* recording the macro when I'm ready. I think in Excel 2007 with the ribbon thrfe isn't a floating MACRO STOP menu bar so it's done through ribbon buttons. So what I need is VBA code to stop the macro recorder if it's currently running. That's all.

I've set the ribbon button to run your alternative code and recorder starts, prompting me to name macro then begins recording. But I don't see the stop button and if I click my button again (re-run your code), it just prompts me to record *another* macro but does NOT stop the one that is currently running. (And nothing done is recorded in the original macro.)

Again, I'm looking for some way for my code to determine that the macro recorder is running, and if so, stop it.

Have I misunderstood how to use your code? ("m running the proc. from my ribbon button, as you've written it.) If not, do you have any more ideas?

Thanks in advance.

**Andy Pope** · 06-11-2009, 11:30 AM

I have an Icon on the status bar that enables the start/stop macro recording.

However this does not appear to function if you use the .Execute method to launch the macro dialog. It changes to the stop button but does not respond to it.

Why not use ribbonx code to add tab/group and button. This will act like the button on the developer tab.

Please Login or Register  to view this content.

**paulzak** · 06-18-2009, 01:07 PM

Andy Pope, this worked perfectly and was what I wanted.
Thank you so much!

**karthisankaran** · 08-03-2012, 04:43 AM

Hi Andy,
I am new to this group. I am developing a project which requires a Button to launch the Macro Recorder using VBA. Please, tell me where do I need to add your code <customUI ... </customUI> in my VBA code module?

**arlu1201** · 08-03-2012, 04:46 AM

Karthisankaran,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.