ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Macro Portability Problem (https://www.excelbanter.com/excel-programming/435773-macro-portability-problem.html)

Ted

Macro Portability Problem
 
I have a worksheet with several macros in it. The macros work properly when
I run them on my computer, but they can't be found when I try the worksheet
on any other computer. how do I ensure the macros will stay with the
worksheet if I move it?

Sam Wilson

Macro Portability Problem
 
They will move with the workbook.

Check the macro security settings on the other computers - in excel 2003 go
to Tools/Macros/Security and set it to Medium, then re-open the workbook and
enable macros. In 2007 you need to go into the trust centre.

Sam


"Ted" wrote:

I have a worksheet with several macros in it. The macros work properly when
I run them on my computer, but they can't be found when I try the worksheet
on any other computer. how do I ensure the macros will stay with the
worksheet if I move it?



All times are GMT +1. The time now is 10:06 AM.

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