Add In - Step By Step Guide

[jaws1972]

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. Could some help me with an idiots guide to :-

a) how to turn a macro into an add-in
b) tell me how when the add-in runs, it creates a custom button and assigns a macro to it.

Both my legs would be extremely grateful for any help on this

 

[PHV]

Why start a new thread ? thread707-771949
Why cross-posting ? thread68-779851

 

[jaws1972]

Sorry PHV

Double posted as I wasn't sure which Forum to use

Second thread as I didn't get enough information for my first one, and I thought nobody would check a post with 5 or 6 replies on it

Apologies