Place VBA macro on each user's/computer's Personal Workbook

[Eunice Harris]

Hi Chandoo experts and TIAFYH! I have admin privileges on my windows network. I've generated a VBA macro - macro with VBA code that every user on my network uses, so I've put it on their Personal Workbooks. Once they switch computers and are new to that computer, I have to add my macro to their personal workbook on the new computer. Our users switch around quite often, it seems like they play musical chairs! My question: is there a way to pre-add, add a macro that can be pre-placed on every user's personal workbook, even before they have first logged in to that computer?
Thanks, Eunice

 

[Chihiro]

You can make it into Excel-Add in. See link below, bit old, but still applies.
http://www.excelguru.ca/content.php?152-Deploying-Add-ins-in-a-Network-Environment