Custom macro and custom button
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
|