| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Macro Issue
Friends,
Can any one suggest me about how to add macro toolbar button in microsoft excel 2007.I have a macro code which is running correctly to my requirement. I want the button to be seen in every excel file when i open.If i click that button macro has to run.Please suggest me only in office 2007. Regards Basanth. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Macro Issue
Add it to the QAT.
Right-click on the QAT and choose Customize. In the first drop-down, select Macros. You will then see your macros, which you can Add to the QAT. -- __________________________________ HTH Bob "basanth" wrote in message ... Friends, Can any one suggest me about how to add macro toolbar button in microsoft excel 2007.I have a macro code which is running correctly to my requirement. I want the button to be seen in every excel file when i open.If i click that button macro has to run.Please suggest me only in office 2007. Regards Basanth. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Macro Issue
But every time i need to write the code if i do in that way.
"Bob Phillips" wrote: Add it to the QAT. Right-click on the QAT and choose Customize. In the first drop-down, select Macros. You will then see your macros, which you can Add to the QAT. -- __________________________________ HTH Bob "basanth" wrote in message ... Friends, Can any one suggest me about how to add macro toolbar button in microsoft excel 2007.I have a macro code which is running correctly to my requirement. I want the button to be seen in every excel file when i open.If i click that button macro has to run.Please suggest me only in office 2007. Regards Basanth. |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Macro Issue
Not if you put the code in your Personal.xlsm workbook.
-- __________________________________ HTH Bob "basanth" wrote in message ... But every time i need to write the code if i do in that way. "Bob Phillips" wrote: Add it to the QAT. Right-click on the QAT and choose Customize. In the first drop-down, select Macros. You will then see your macros, which you can Add to the QAT. -- __________________________________ HTH Bob "basanth" wrote in message ... Friends, Can any one suggest me about how to add macro toolbar button in microsoft excel 2007.I have a macro code which is running correctly to my requirement. I want the button to be seen in every excel file when i open.If i click that button macro has to run.Please suggest me only in office 2007. Regards Basanth. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoFill Macro Issue | Excel Discussion (Misc queries) | |||
| AutoFill Macro Issue | Excel Discussion (Misc queries) | |||
| AutoFill Macro Issue | Excel Discussion (Misc queries) | |||
| Formula and Macro for issue...can it be done | Excel Discussion (Misc queries) | |||
| Easy macro issue (I think) | Excel Discussion (Misc queries) | |||
Linear Mode
