trouble running macro w/personal.xls

redneckopen

Board Regular
Joined
Nov 2, 2004
Messages
224
When a coworker runs a macro that I made, in Tools>References there is Missing-personal.xls checked when she fires up the program. Why would that be? How can I fix?
 

Excel Facts

Select a hidden cell
Somehide hide payroll data in column G? Press F5. Type G1. Enter. Look in formula bar while you arrow down through G.

xapie128

Board Regular
Joined
Aug 26, 2006
Messages
82
I appears that you created your macro in your Personal.xls file, which resides on your hard drive. When you create the macro, you need to select Save Macro In: This Workbook. That way it stays with the .xls file and can be transferred to another computer.

The Personal.xls method is good for macros that you might want to run at any given time, without having to load a specific workbook. But it isn't transportable to another computer (unless you copy and overwrite the Personal.xls file, that doesn't reside where the rest of your .xls files do).
 

Forum statistics

Threads
1,136,993
Messages
5,679,023
Members
419,800
Latest member
spvsr999

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