| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro toolbar button problem
I've created a short macro and I've added a button to the excel toolbar (I'm
using excel 2007). The macro security setting is set to enable all macros...but when I open up another excel sheet other than the one that the macro was created in and try to run the macro.. I get the following error: "Cannot run the macro "XXX". The macro may not be available in this workbook or all macros may be disabled." Any ideas on how to solve this problem? I'm sure it's probably easy but I can't seem to figure it out. Thanks in advance!! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
macro toolbar button problem
I got it! Personal.xls in XLSTARTUP folder!
"NewToVB" wrote: I've created a short macro and I've added a button to the excel toolbar (I'm using excel 2007). The macro security setting is set to enable all macros...but when I open up another excel sheet other than the one that the macro was created in and try to run the macro.. I get the following error: "Cannot run the macro "XXX". The macro may not be available in this workbook or all macros may be disabled." Any ideas on how to solve this problem? I'm sure it's probably easy but I can't seem to figure it out. Thanks in advance!! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro button on toolbar | Charts and Charting in Excel | |||
| Button with macro in toolbar | Charts and Charting in Excel | |||
| Macro button on toolbar | Excel Discussion (Misc queries) | |||
| Macro Toolbar Button | Excel Programming | |||
| Toolbar button To Run a Macro? | Excel Programming | |||
Linear Mode
