How do I record a macro in Excel 2010 ?
by rcgyuk - 9/25/12 1:41 AM
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?