Make sure that:
the function is in a normal module (NOT an object module)
the module does NOT have option private module
the function does NOT have private prefix
then it works fine for me.
in VBE
in Project window select your addin.
in Object browser
Select your addin's project
The function should be visible under globals
(at the bottom you should see that it's a public function)
Tip:
While you're in the object browser:
Right click the function:
select properties and you can enter a description which is visible in
the Formula Dialog in Excel
keepITcool
< email : keepitcool chello nl (with @ and .)
< homepage:
http://members.chello.nl/keepitcool
"?B?UGV0ZXIgV29vZA==?="
wrote:
I have a function - Public Function GetDescription() - which worked
fine when tested in the original Workbook. I then saved it as an XLA
and loaded the add-in via the tools menu, but I can't find out how to
run the function! Its not listed in the Tools/Macros or
Insert/Function, and if I type =GetDescription() in a cell, the result
is #NAME? - which is the same as if I type in rubbish like =xcvr().
Can someone give me some guidance? I just want to assign it to a
shortcut key.