Hi Jugglertwo,

Sharing macros with your co-workers can be a great way to increase productivity and efficiency in the workplace. Here are some steps you can take to share your macros:

1. Export the macros as an add-in file: The best way to share macros with your co-workers is to export them as an add-in file. This will allow your co-workers to easily install the macros on their own computers without having to manually copy and paste them into their XLSTART folder. To do this, go to the Developer tab in Excel and click on "Add-Ins". Then, click on "Excel Add-Ins" and select "Browse". Navigate to the location where you want to save the add-in file and give it a name. Make sure to select the "File Type" as "Excel Add-In (*.xlam)" and click "OK". This will create an add-in file that you can share with your co-workers.
2. Avoid using Personal.xls: While you could send them a copy of the Personal.xls workbook and have them put it in their XLSTART folder, this is not the recommended method. The Personal.xls workbook is specific to your computer and may contain macros that are not relevant or useful to your co-workers. Additionally, if your co-workers have their own Personal.xls workbook, it could cause conflicts and errors.
3. Ensure safety and documentation: Sharing macros at work is generally not a problem as long as you are following company policies and guidelines. However, it is important to make sure that the macros you are sharing are safe and do not contain any malicious code. It is also a good idea to document what the macros do and provide instructions on how to use them.