Custom macro and custom button

  • Thread starter Thread starter VLExcel
  • Start date Start date
V

VLExcel

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.

Button>Excel Options>Customize>Choose 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
 
Back
Top