Macro in Workbook Doesn't Work When Opened On Another Computer Pat Adams 12/19/2008 4:25:01 PM 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?

Re: Macro in Workbook Doesn't Work When Opened On Another Computer "Bob Flanagan" <nospam[ at ]nospam.net> 12/20/2008 8:44:02 PM Pat what do you mean "does not work"? Nothing at all? Or an error message? Try setting macro security to low and opening and closing Excel then trying. If that works, set back to medium. Robert Flanagan http://www.add-ins.com Productivity add-ins and downloadable books on VB macros for Excel "Pat Adams" <PatAdams[ at ]discussions.microsoft.com> wrote in message news:0733C0F9-BB93-4C80-8394-42560DAC53A6[ at ]microsoft.com... [Quoted Text] > 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?

Re: Macro in Workbook Doesn't Work When Opened On Another Computer Pat Adams 12/21/2008 1:50:01 PM 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. "Bob Flanagan" wrote: [Quoted Text] > Pat what do you mean "does not work"? Nothing at all? Or an error message? > Try setting macro security to low and opening and closing Excel then trying. > If that works, set back to medium. > > Robert Flanagan > http://www.add-ins.com > Productivity add-ins and downloadable books on VB macros for Excel > > "Pat Adams" <PatAdams[ at ]discussions.microsoft.com> wrote in message > news:0733C0F9-BB93-4C80-8394-42560DAC53A6[ at ]microsoft.com... > > 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? > > >