Josh_Blade
asked on
Calling a UDF addin in the personal work book
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
Compile Error:
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?
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
Compile Error:
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?
Make it Public rather than Private.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Messed around and got it working.