A workbook that automatically installs macros
Hi,
I have a few macros tha I have written and I would like to be able to distribute them to work colleagues. The macros are stored in the personla.xlsb file, on my pc. Office version 2010.
Ideally I would like to have a workbook, in which there are separate buttons to install each macros. The colleagues would open this workbook and install the macros that they want. This workbook would access the personal.xlsb file (which I would place on a network drive), copy it onto the colleague's computer and then install the macro in the ribbon and assign it an icon.
Is this possible to do and if so how? Or is there a simpler way of doing the same thing?
Thanks a lot
Recent comments
5 years 36 weeks ago
6 years 22 weeks ago
6 years 34 weeks ago
6 years 37 weeks ago
6 years 38 weeks ago
6 years 43 weeks ago
6 years 52 weeks ago
7 years 2 days ago
7 years 3 days ago
7 years 3 days ago