I've written a bunch of functions I'd like to spread with my coworkers. Knowing most of them don't know how to install an add-in manually I was thinking if this could be done with a macro.
I'm thinking something along the lines of sending them the functions as a normal worksheet with a macro that saves the workbook as an add-in and installs it automatically. No need to add new menu items or anything: all I want is the functions to be available without having to open a separate function workbook.
Does anybody know how to do this?
I'm thinking something along the lines of sending them the functions as a normal worksheet with a macro that saves the workbook as an add-in and installs it automatically. No need to add new menu items or anything: all I want is the functions to be available without having to open a separate function workbook.
Does anybody know how to do this?
