Question

How do I record a macro in Excel 2010 ?

I am in the process of moving from Excel 2003 to Excel 2010

In Excel 2003, I have added a custom button to the toolbar called 'T1', and recorded a macro called temp1.

This macro is then assigned to button 'T1'

(I also have T2 - T10, but if I can create one I suspect I can create them all)

So if I record a sequence of actions to a macro called temp 1, I can replay these actions with a single click of button 'T1', which is really useful if I have to do the same edits to 10 identical spreadsheets.

How can I replicate this in Excel 2010?

Robert

Discussion is locked
Follow
Reply to: How do I record a macro in Excel 2010 ?
PLEASE NOTE: Do not post advertisements, offensive materials, profanity, or personal attacks. Please remember to be considerate of other members. If you are new to the CNET Forums, please read our CNET Forums FAQ. All submitted content is subject to our Terms of Use.
Reporting: How do I record a macro in Excel 2010 ?
This post has been flagged and will be reviewed by our staff. Thank you for helping us maintain CNET's great community.
Sorry, there was a problem flagging this post. Please try again now or at a later time.
If you believe this post is offensive or violates the CNET Forums' Usage policies, you can report it below (this will not automatically remove the post). Once reported, our moderators will be notified and the post will be reviewed.
Comments
- Collapse -
Answer
Re: record macro
- Collapse -
Re: record macro

I managed to record the macro, where I am stuck is adding a button to the toolbar, and assigning the macro to it.

The link you gave shows how to add a custom group to the developer tab, and add your macro to it.

To run the macro will take 3 mouse clicks, where as a visible button on the toolbar with an assigned macro can be run with a single mouse click, as in excel 2003

That is what I am trying to do

- Collapse -
Answer
I answered the question in your subject line.

Indeed, not the other ones in your post.

Kees

- Collapse -
Re: having added custom button, how to modify it

Hi,

Am nearly there, have got a button added to quick access toolbal, with macro temp1 assigned, and if I hover the mouse over the button, the text 'T1' pops up.

But in Excel 2003, you can change a button from 'default style' to ' Text only (always) '

Then you see T1 T2 etc on your toolbar, not a row of random buttons.

If I can do this, I will have what I have always had in 2003

Thanking you for your patience.

Robert

CNET Forums