Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid using macro's from other workbook(s)
How can I avoid using macro's from other workbook(s)?
I often have several workbooks open using nearly simular macro's with the same ctrl-letter combination to activate them. E.g. when I press ctrl-e in workbook A it uses the according macro from workbook B or C. How to force VB to use the correct macro? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Avoid using macro's from other workbook(s)
hi
if you have several macro from several workbooks all activated by the same keyboard shortcut then you are confusing excel. change the keyboard shortcut or run the macro from the macro dialog. regards FSt1 "Henk" wrote: How can I avoid using macro's from other workbook(s)? I often have several workbooks open using nearly simular macro's with the same ctrl-letter combination to activate them. E.g. when I press ctrl-e in workbook A it uses the according macro from workbook B or C. How to force VB to use the correct macro? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Close Workbook If user disables macro's | Excel Programming | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
Avoid to reopen a working Workbook | Excel Programming | |||
Avoid Deleting a Shared Workbook using VBA | Excel Programming | |||
Detect macro's parent workbook or worksheet | Excel Programming |