If you select Tools - Macros - Macros... you get a list of macros. Select a macro and click Options... You're then presented with a box that allows you to set a Shortcut key. Either Option+Cmd (for a lower case letter) or Ctrl+Shift (for an upper case letter).
It doesn't matter what I enter into the little box. Nothing works. No letter, upper or lower case, seems to work.
Since generally keyboard shortcuts seem to be an issue has this ever worked?
Jonathan Bowman commented
So here is the deal, I'm making a very heavily modified excel spreedsheet with macro enabled features and I accidently locked down and erased my ability to execute macro in this workbook. I'm going crazy trying to find out how to reenable those features, however NONE of the macro reenable feature options are working for me. Maybe you could create a restore previous macro functions option for future reference ? I would really like to not lose 6 weeks of VBS code i've compiled into Macros. Thank you Microsoft.