I have created a number of macros that I'm happy with and want to make it available for general use in my department. I have two scenarios relating to the general use and distribution of the macros:
1) When I start up a new Excel application or workbook I want to be able to have access to the macros. I read about using Worksheet Events but it doesn't seem to be the answer since I don't want to use the original spreadsheet that I created, but rather have the macros available whenever I open a new workbook.
2) I want my co-workers to have access to the macros without me having to send my original spreadsheet (that contain all macros) to each person. Again, I read about the application of 'add-in', but I'm not sure if that the best way to go about it.
I'm not sure where to start, so I would like to ask for the best way to handle this?