How do I move macros from one computer to another?
D David Billigmeier Sep 26, 2005 #2 In the VBA editor, right click on the sheet name or module name (in the left panel)that contains the macro and click on "Export File"
In the VBA editor, right click on the sheet name or module name (in the left panel)that contains the macro and click on "Export File"
C Chip Pearson Sep 26, 2005 #3 Macros are always stored in workbooks, so you can simply copy the workbook containing the macros from one machine to another. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
Macros are always stored in workbooks, so you can simply copy the workbook containing the macros from one machine to another. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com