DLL loading question

[trumanchua]

[FONT=Segoe UI, Lucida Grande, Verdana, Arial, Helvetica, sans-serif]so i'm reading this link

[/FONT]https://msdn.microsoft.com/en-us/library/office/bb687915.aspx#sectionSection2

i've created a spreadsheet

i'm able to do a Public declare of my DLL function called "myfunc" and write a VBA macro calling that DLL function called "mymacro"

then i enter that macro name in cell A1 like so "=mymacro(param1, param2) - everything works

now i go to cell B1 and type in "=myfunc" where "myfunc" is the name of the DLL function that i've just accessed previously thru "mymacro"

now i get a #Value from excel

why ?

now if i deleted all my VBA code in the same spreadsheet and simply load the same DLL thru the ADDIns Manager and then call the same DLL function "myfunc" directly in a cell - "=myfunc(param1, param2)"

again everything works

so what i've outlined here are 2 of the methods described in the article referenced at the top of this post - am i right to assume that only one of these methods can be implemented at any given time ? they can't mingle/co-exist ?