Selected Answer
I'm not Don, but I will try to help.
There are multiple places.
(events are normal macros but they are automatically fired when specific thing happen, for example workbook_open fires when you open the file).
Bold are most important causes.
- First there are modules and you should use them when this macro will be used in more than one sheet and also modules are easy to be imported and exported.
- You could also have macros in the sheet and you should use this when you use this macro on this sheet (you could use it outside it) and when you have events on this sheet (like worksheet_change).
- And in "this workbook" you could have the macros that you use on multiple sheets or events on the workbook (like workbook_Open).
- I should note also that you have a PERSONAL.XLSB file (it will be created automatically when you record macro and store it in Personal Macro Workbook) and you could use this file for storing your macros that you use on multiple Workbooks , you have modules and sheets and this workbook in this file but modules are most important in this file (you could use sheets and this workbook if you want).