In the excel 2003, i used to have a few specific macros i created and saved
in my Personal.xls file. These macros were basically setup to format a
specific cell a certain way. I then had added a few "Custom" buttons for
the toolbar and assigned each of these macros to a specific button. That
way, i could just push a button on the toolbar, and it would run my macro and
format the highlighted cells the way I wanted.

Can anyone tell me how to do this in Excel 2007?
thanks
V

If just a few you can add them to the QAT.

ButtonExcel OptionsCustomizeChoose Commands from:

Select Macros.........assuming Personal.xls is running, of course.

You can then select and "Add"

Note: you can "Modify" the button faces from the "added" side of dialog.


Gord Dibben MS Excel MVP

On Fri, 9 Apr 2010 08:56:01 -0700, VLExcel
wrote:

In the excel 2003, i used to have a few specific macros i created and saved
in my Personal.xls file. These macros were basically setup to format a
specific cell a certain way. I then had added a few "Custom" buttons for
the toolbar and assigned each of these macros to a specific button. That
way, i could just push a button on the toolbar, and it would run my macro and
format the highlighted cells the way I wanted.

Can anyone tell me how to do this in Excel 2007?
thanks
V