I am just getting started with macros and VBA in Excel 2003, and am trying to create a set of macros that can be used across all other worksheets from now on. From what I have read so far, the best way to accomplish this is to save the macros as an add-in (.xla file).
The macros work correctly and I am able to save them as an add-in .xla file, but then when I open a new workbook and load the add-in, the macros don't show up when I go to Tools->Macro->Macros. I did some searching and apparently any macros in an add-in file will never show up in that menu. Is that correct?
If so, then how am I supposed to set bindkeys for macros that I store in an add-in? The only way I know to set bindkeys is to access the macro in the list that appears when you go to Tools->Macro->Macros, and then click Options. This allows you to then set the bindkey. If the macro never appears in that list, how do I assign it to a bindkey?
The macros work correctly and I am able to save them as an add-in .xla file, but then when I open a new workbook and load the add-in, the macros don't show up when I go to Tools->Macro->Macros. I did some searching and apparently any macros in an add-in file will never show up in that menu. Is that correct?
If so, then how am I supposed to set bindkeys for macros that I store in an add-in? The only way I know to set bindkeys is to access the macro in the list that appears when you go to Tools->Macro->Macros, and then click Options. This allows you to then set the bindkey. If the macro never appears in that list, how do I assign it to a bindkey?
