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?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
trouble running macro w/personal.xls
- Thread starter redneckopen
- Start date
Excel Facts
Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
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).
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).
Upvote
0
Similar threads
- Question
