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

**romperstomper** · 05-06-2010, 11:14 AM

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...

**Skywalker** · 05-06-2010, 11:19 AM

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.

**Skywalker** · 05-07-2010, 12:55 PM

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?