Personal Macro

[Genetu]

Good morning, guys. I have tried many times to call my personal macro procedures from "This Worksheet" using 'OnKey' (assigning Keyboard shortcut). But I can't do that. Is there any way to call my personal macro modules from the "This Worksheet" code? And how can I activate my personal macro keyboard shortcuts available for all workbooks as we did in "This Worksheet" for the "Open_Workbook" event?

 

[davesexcel]

Could you not call the code instead of using onKey?

 

[Genetu]

davesexcel, first thank you for your response. I can call them but I can't use the shortcut key. Shortcut keys are faster than assigned tab icons to process.

 

[davesexcel]

I guess I got confused when you used the term "This Worksheet" and "OnKey"

To clarify, you have shortcut keys to run macros from your personal macro workbook, but they don't work?

 

[Genetu]

I guess I got confused when you used the term "This Worksheet" and "OnKey"

To clarify, you have shortcut keys to run macros from your personal macro workbook, but they don't work?

Ok, devesexcel. Let me explain, we can use the (Workbook_Open) event in the worksheet code module (This workbook). This will make the code active when the workbook is open even if the shortcuts are assigned using "Onkey". But the shortcut keys are not active in the personal macro-VBA. we can assign using "Onkey" but it is not active as the" Workbook_Open" event. I have attached an image here.