Hi friends!



Is it a sin to store a macro and it hotkey trigger in the document level as opposed to the template?

What I am puzzled with is that I have a group of macros that are basically the same function but vary slightly from doc to doc. I want to assign the same hotkey to the macros to execute the macro that is meant for that specific doc. But hotkey-macro connections are stored in at the template level so this will not work correctly for each doc.
Maybe my whole methodology is mistaken here...

Sincerely, a confused flamingo

Update edit:

I thought I could do an if statement getting the title property of the document and executing the macro as desired for each doc.

You certainly can store macros and hotkeys both in documents.

If your macros are in your documents and you store your hotkey globally but the macro is in the same module with the same name in each document, the hotkey should trigger the macro in the document rather than a globally stored macro.
See:

• The Hierarchy of Templates in Microsoft Word
• Assigning Keyboard Shortcuts in Microsoft Word 2007-2021 (365)

If you use a global template for the shortcut, there should be a macro stored in the global template that will respond to it if there is not a macro in the document.


If I were doing this, though, I would not put a separate macro in each document, but rather use a document variable in the document and have a central macro that performs the action and varies according to the presence and value of that variable.

Chris Woodman's Keyboard Shortcut Organizer contains a utility to let you read, set, and modify document variables from within the user interface, without going to the vba editor. Chris Woodman's Keyboard Shortcut Organizer

Storing macros and their hotkey triggers at the document level can have its benefits. One approach to solving your problem might be to use a macro that will assign a hotkey depending on the document. You can use the document's Title property to determine which macro to assign to a hotkey.