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 34 weeks ago
6 years 20 weeks ago
6 years 32 weeks ago
6 years 35 weeks ago
6 years 36 weeks ago
6 years 42 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago
6 years 50 weeks ago