Calling a UDF addin in the personal work book
Posted on 2012-03-13
I have a user defined function. I created an addin for it so that it would show up in every work book and that works fine and the function works well.
I also created a macro in my personal workbook that calls the udf.
When my udf is defined in an individual workbook, the macro and udf work great, but when I have the udf as an add-in (so that I don't have to add it to every workbook), I get a
Sub or Function not defined and it highlights my udf.
I basically want to be able to run my macro from any workbook (hence why I put it in my personal workbook), without needing to add the function to every workbook (which is why I put it in as an add-in).
Any ideas as to why the personal workbook macro won't recognize my udf when it's in an add-in?