View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Sam Wilson Sam Wilson is offline
external usenet poster
 
Posts: 523
Default 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?