I am using shortcut keys to trigger macros on my Calc documents. For this, I use the [Tools > Customize > Keyboard] dialog box. There, I can only assign shortcut keys at the Calc level or at the LibreOffice level, not at the document level. In other words, if I assign Macro1 to [CTRL+SHIFT+M] for my Calc1.ods sheet, I cannot assign the same shortcut keys to Macro2 for my Calc2.ods sheet. If I try it, it overrides the previous setting.
Is there a way this can be done though?
Help would be much appreciated since using shortcut keys is a very convenient way to invoke macros when working on a document, specially for repetitive tasks. I often use it on my Calc documents and I can’t see myself having to remember the plethora of shortcut keys that would need to be assigned for each document (all the more so when they share somewhat the same structure and the macros perform similar tasks).