CODEWITHSUNDEEP
vbaexcelexcel-addins

Reputation:

Trouble Creating Excel add-in from macro

I've created two VBA macro functions that worked fine when used in the current workbook. I saved as .xla and imported as an add-in. I then found and activated the add-in through the menus in excel but when I use the functions I get the #NAME error and a description of "The formula contains unrecognized text". I'm stuck.

Upvotes: 1

Views: 1244

Answers (1)

Jon Fournier
Jon Fournier

Reputation: 4327

If you open the VBA editor, does your addin show up in the list? I've had problems before with Excel VBA addins where even though the Addins list says an addin is loaded, it doesn't show up in the VBA editor unless I uncheck it and recheck it in the list. It's pretty annoying, and I haven't found a way to find the list of Addins I've selected, in order to automatically reload them if necessary...

Hope that helps...

Upvotes: 1

Related Questions