If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Custom macro and custom button
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 |
#2
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|