can u save a macro for to email and then someone else can incorporate it?

[maxmadx]

I, through the help on this forum, have created a macro which I want to share among others in the office. I want them to save it onto their pc then open/import it into their excel. They can then use this for all workbooks (like save to personal workbook), Can you do this?

(ideally when the file is imported there is a buton on the toolbar ready to go!

Cheers,

Steve

 

[iliace]

I would save it as an add-in. And add a toolbar with whatever buttons you require.