- Joined
- Jan 21, 2014
- Messages
- 1
- Reaction score
- 0
- Points
- 1
I'm running Excel 2011 on Mavericks. I created a Personal Macro Workbook (PMW) by recording a macro and saving it. The PMW has that name (no extension) but its type is a "Microsoft Excel binary workbook". It is stored in the correct folder in Library. I imported a couple other macros in it. These macros work fine in the workbook in which they were created.
When I create a new workbook, the following is true:
1. The PMW is opened (I see the temp file in the folder).
2. I can open and edit the macros in the VBA editor.
3. When I start to type the name of a macro (UDF) in the workbook its name shows up in the completion list.
4. No macro from the PMW shows up in the macro list on the Developer Tab.
5. When I calculate the UDF the cell displays "#NAME?".
6. A breakpoint set in the UDF never gets executed, implying the code is not found.
As an aside, I copied the PMW to the XLSTART folder in a Parallels VM running Excel 2007. After renaming the workbook, it works fine, i.e., UDF provides the correct value when used in a new Windows workbook.
Can someone tell me what is going on and how I can correct it?
Thanks.
When I create a new workbook, the following is true:
1. The PMW is opened (I see the temp file in the folder).
2. I can open and edit the macros in the VBA editor.
3. When I start to type the name of a macro (UDF) in the workbook its name shows up in the completion list.
4. No macro from the PMW shows up in the macro list on the Developer Tab.
5. When I calculate the UDF the cell displays "#NAME?".
6. A breakpoint set in the UDF never gets executed, implying the code is not found.
As an aside, I copied the PMW to the XLSTART folder in a Parallels VM running Excel 2007. After renaming the workbook, it works fine, i.e., UDF provides the correct value when used in a new Windows workbook.
Can someone tell me what is going on and how I can correct it?
Thanks.
