ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Storing Macros (https://www.excelbanter.com/excel-programming/302693-storing-macros.html)

jc lewis

Storing Macros
 
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

Storing Macros
 
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.

--
Regards,
Tom Ogilvy

"jc lewis" wrote in message
om...
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





All times are GMT +1. The time now is 07:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com