I'm running Excel 2011 on Mavericks. I created a Personal Macro Workbook (by recording a macro). It 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 PMW.
3. When I start to type the name of a macro (UDF) it's 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?".

As an aside, I copied the PMW to a Parallels VM running Excel 2007. After renaming the workbook, it works fine, i.e., UDF provides correct value in a new Windows workbook.

Can someone tell me what is going on and how I can correct it?

Thanks.