Macro does not work when file is sent to another computer

[geddes_1310]

I have created a simple macro in this excel spreadsheet. Everything works fine until I sent the attachment to my boss. It does not work and keep showing s pop up error msg.

What could be wrong?

 

[xld]

Don't you thin k it might help if you showed us the code and tell us where it errors, or shall we just guess?

 

[jdc]

It could be several things,

1. is your macro stored in the actual worksheet or in your personal.xls workbook.

2. is your bosses macro security level set to allow your macro to run.

hth

john

 

[drhatmrexcel]

I have created a simple macro in this excel spreadsheet. Everything works fine until I sent the attachment to my boss. It does not work and keep showing s pop up error msg.

What could be wrong?

Perhaps your boss has an older version of Excel ie some of my macros wriitn in Excel 2007 do not work in our offices Excel 2000 machines.

 

[bertie]

It could also be your marco uses references which are not set on the other pc.

Click Tools => References to check