Link to home
Start Free TrialLog in
Avatar of Josh_Blade
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?
Avatar of Martin Liss
Martin Liss
Flag of United States of America image

Make it Public rather than Private.
ASKER CERTIFIED SOLUTION
Avatar of Josh_Blade
Josh_Blade

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Josh_Blade
Josh_Blade

ASKER

Messed around and got it working.