I have a macro that formats an Excel Spreadsheet, by adding the filename and date/time to the footer
Personally I have it saved in my Personal.xls, and is tied into a custom button on my toolbar
I have been asked to role it out to everyone in the Company (over 100 users) and I am a bit reluctant to go to each individual user to do this.
I have heard it is possible to turn the macro into an Add-In, which I have sort of done (and I mean sort of !!)
What I don't have is the first part of the add-in. The part that will create a custom button, copy the macro and save it to the users Personal.xls, and attach the macro to the button
Can anyone help me please
Personally I have it saved in my Personal.xls, and is tied into a custom button on my toolbar
I have been asked to role it out to everyone in the Company (over 100 users) and I am a bit reluctant to go to each individual user to do this.
I have heard it is possible to turn the macro into an Add-In, which I have sort of done (and I mean sort of !!)
What I don't have is the first part of the add-in. The part that will create a custom button, copy the macro and save it to the users Personal.xls, and attach the macro to the button
Can anyone help me please