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
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
