Installing macros to other pc's

[HomePro]

I wrote a small macro that basically deletes useless info and formats the remaining. I need to run this daily on reports generated by our system so I stored it in my Personal Macro Workbook for easy access. And this is working fine. However there are 15 members in my team that could all benefit from this macro. I am not exactly "Macro Savy" but they are even less. They do not have the developers options active and possible not even enabling of macros in options. Short of my sitting and installing this at every pc --- is it possible to create a macro that will enable the macro option in excel and install a copy of my macro in there Personal Macro workbook?

 

[Joe4]

You may want to consider creating an Add-In, and sharing that with your team members.
See: How to Create and Use an Excel Add-in (Step-by-Step Tutorial)