Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi All.....
I put drawing objects and .jpg's in some of my workbooks and assign macros to them. The macros are in that workbook. This works fine, except sometimes Excel places the WorkbookName in front of the MacroName in the "assigned to" link. This also works fine unless I change the name of the Workbook. The "button" is now married to the old WorkbookName so it tries to find that workbook to run the macro. I change the AssignMacro wizard to exclude the WorkbookName but Excel keeps putting it back there. This doesn't happen on ALL the macros I assign to "buttons", just some. How can I permanently remove the WorkbookName from the MacroName when assigning the macro to a "button"? I want the button to trigger the named macro in the current active workbook only. TIA Vaya con Dios, Chuck, CABGx3 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
filename!macroname as variables | Excel Discussion (Misc queries) | |||
Quarterly Leads Tracking Template | Excel Discussion (Misc queries) | |||
need to track sales leads and appointments what software do I nee | Excel Discussion (Misc queries) | |||
Is there a free excel spreadsheet for tracking leads? | Excel Discussion (Misc queries) | |||
Organize spreadsheet of sales leads by zip code? | Excel Discussion (Misc queries) |