Storing Macros

[jc lewis]

What is the best way to store a macro so I can put it on different
Machines. Are there any problems I should expect from doing this?

Thanks
jc lewis

 

[Tom Ogilvy]

Macros are stored in workbooks or addins (a workbook as well). An addin is
probably the best way to store the macro, but it depends on how it will be
used. Macros in an addin do not appear in Tools=>Macro=>Macros. If you had
you addin create a toolbar, then that could overcome accessibility.