Hello.

Does anyone know how it is possible to turn a macro that is saved in
the personal macro workbook into an Excel add-in, so that it stays in
the Add-in section of the tools menu, and when checked adds the extra
buttons to the toolbar that run the macros automatically?

I seem to remember a while back being able to get the add-in part done
and have it in the add-in section of the tools menu, but could never
get it to also put the buttons in automatically that are used to run
the two macros.

I would like to be able to save this as an add-in on a remote drive
accessible to everyone, instead of having it on everyones individual
computers.

A lot of other add-ins I have seem to add buttons into the toolbar to
activate macros, but I could never get it to do that for the macros I
made.

Cheers very much for any help

John