Macro Options

Oct 24, 2014 at 7:15 PM
I am creating an XLSM spreadsheet and have successfully inserted the source code in a VBA Module. How do I set the options to assign a keystroke to execute the macro in Excel? In OLE, I would have used the xl.MacroOptions routine.
Oct 24, 2014 at 8:12 PM
Here is my rather clunky solution:
At the end of the VBA code, I added an Auto_Open routine that assigns the desired keystrokes to the new macros. Now, every time the spreadsheet is opened, the appropriate keystrokes are reassigned to the macros.