Running the macro below requires that you set the option to Trust access to the VBA Project object model in the Trust Center settings and also that you set references in VBA as listed in the code. I don't know the significance of the \n14 at the end (and I am not sure if it will be consistent as I have not extensively tested this. The bolded information above is the name of a macro, and the associated shortcut key. The line in the exported file that has this information looks like:Īttribute MacroShortCutKeys.VB_ProcData.VB_Invoke_Func = " a\n14" That file can then be parsed to return the procedure name and the associated shortcut key. It turns out although the shortcut key cannot be accessed "directly", if you export a module, any shortcut key is listed in the exported file. You can list the keys assigned to a macro with a VBA macro.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
December 2022
Categories |