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
When did Power Query debut in Excel?
Although it was an add-in in Excel 2010 & Excel 2013, Power Query became a part of Excel in 2016, in Data, Get & Transform Data.
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
