Hi, gurus, please help me with my problem
I want to create macros with macro recorder, assign it to keyboard shortcut and save to external file. When I create macros 3 options of saving option is available:
1) Active document
2) ARROW_M.VSS
3) EPC_M.VSS
When I use save option - 1) Active document, my macros works good, I can run it from menu and keyboard shortcuts.
But when use save options - 2) ARROW_M.VSS , 3) EPC_M.VSS - my macros can run only from menu, it doesn't work through keyboard shortcuts.
So I need the way to save macros in external file, and use it with different workbooks. And also,I need to run my macros through keyboard shortcut.
In Ms Excel, I saved macros in Personal.xlsb for my purposes and everything was good.
I use MS Visio 2010. Thank you for you suggestions ))