Macro does not work when file is sent to another computer

geddes_1310

New Member
Joined
Sep 13, 2009
Messages
20
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?
 

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

xld

Banned
Joined
Feb 8, 2003
Messages
5,378
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

Active Member
Joined
Nov 23, 2004
Messages
263
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

Board Regular
Joined
Oct 30, 2009
Messages
69
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

Well-known Member
Joined
Jun 12, 2009
Messages
1,869
It could also be your marco uses references which are not set on the other pc.

Click Tools => References to check
 

Forum statistics

Threads
1,181,648
Messages
5,931,213
Members
436,784
Latest member
amuljono

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top