HomePro
Board Regular
- Joined
- Aug 3, 2021
- Messages
- 157
- Office Version
- 365
- 2021
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- 2003 or older
- Prefer Not To Say
- Platform
- Windows
- MacOS
- Mobile
- Web
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?