Avoid using macro's from other workbook(s)

H

Henk

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?
 
F

FSt1

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook macro's 3
Updating Macro's in Multiple Workbooks 5
Run code from another workbook 7
Test if workbook is not yet named 2
Disconnecting from an External Workbook Data Source 2
Activating a renamed workbook 10
Activating a renamed workbook 2
Call macro from active workbook-duplicate shortcut keys 1

Top