View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Wood Peter Wood is offline
external usenet poster
 
Posts: 2
Default How do I access XLA functions?

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.