Macro in Workbook Doesn't Work When Opened On Another Computer

[Pat Adams]

In our offices, we have employees working with several versions of Excel. I
created a macro to help production print only the pages it needs from a
workbook, and then saved it inside the workbook so that it would be available
to anyone using the workbook.

However, when the workbook is opened on another computer (although it asks
if macros should be enabled/disabled), the macro does not work. I am running
Office 2003; the other computers are using Excel 2002 and 2007. Suggestions?

 

[Pat Adams]

The macro does not work at all (no error message). I will try the macro
security setting changes on Monday and reply with those results. Thanks.