Calling Personal.xls functions without needing a 'personal.xls!' prefix

I have VBA functions saved in Personal.xls, which I need to call with a 'personal.xls!' prefix, or I get the #NAME? error. I do have the Personal.xls file open but hidden.

Is there any way to have the personal.xls functions be global, and not require the personal.xls! prefix?

Thanks. Seems the project is already titled projPersonal, but in the Available References list, I don't see projPersonal displayed even though I have the Personal.xls file open and projPersonal is displayed on the left. Do I have to do something to make it listed under Available References?

It doesn't for me, either alphabetically or in the short list of non-alphabetical references at the top. I tried renaming it 'AAAprojPersonal' to make it easier to find in case I somehow missed it (the list is large), but I still don't see it. Looked under where Personal would be alphabetically as well.

In the References window I went to Browse and located my PERSONAL.XLS file. Opening that caused projPersonal to appear at the bottom of the Available References list, but when I checked it and hit OK I get the error 'Name conflicts with existing module, project, or object library'.

Originally Posted by romperstomper

If you set the IsAddin property of the Personal.xls to True, then you don't need the prefix. Of course, none of your macros will appear in the macro list...

Thanks, that worked for the VBA functions I don't have any macros so I'm not sure what the effect there is.

Seems that this actually isn't saving once I quit Excel. After I change IsAddin to True and save in the VB editor, I don't need the prefix - but if I quit Excel, then the prefix becomes needed again, and IsAddin reverts to False.

How can I have this change stick?

Thanks, that seems to have the same effect as saving from the save icon though, which is how I saved previously. The value doesn't stay True on reopening.

When I make IsAddin True and save, either by icon or immediate window, and close the VB editor, Personal.xls disappears - it closes if I had it open, and if I had it hidden I can no longer unhide it as the 'Unhide' option in the Windows menu is greyed out. And I can use the personal.xls functions without the prefix, which is what I want.

But if I exit Excel, upon reopening, Personal.xls is open as the default instead of Book1. And the IsAddin property is False once again. So prefixes are needed again.

Is there some other step I'm missing?

I don't know how to do that. Where can I find a good tutorial for that?

Might there be some reason why things that are supposed to work don't work for me? e.g., projPersonal not being listed under Available References, and the IsAddin value not saving.