#NAME? error for user-defined vba function

**psychopsanka** · 09-30-2009, 02:17 PM

I wrote the following function in a standard VBA Module (not a Class Module):

Please Login or Register  to view this content.

After saving and returning to a worksheet, any call to the function yields a #NAME? error. I also tried to save, exit Excel, and reopen, but still no luck. Any advice would be appreciated. Thank you.

**shg** · 09-30-2009, 02:19 PM

You saved as an xlsm file?

Macro security is set to Medium?

You enabled macros when the workbook opened?

**psychopsanka** · 09-30-2009, 02:41 PM

I have the function saved in a Module in my PERSONAL.XLSB file so I can use it whenever I open Excel. I know that if I copy the code into a Module for a given macro-enabled worksheet that I'll be able to call the function on that specific worksheet, but I want to have access to this function at all times...but yes, macro security is set to medium and the workbook I want to run it in is macro-enabled (.xlsm).

Thanks for the help.

**shg** · 09-30-2009, 03:01 PM

Either preface the call

=personal.xlsb!mymacro(...)

... or in the VBE set a reference in the workbook to Personal.xlsb.

If you choose the latter, then name the project in Personal (mine is projPersonal), and in the VBE, Tools > References, find it, tick it.