View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
naive14 naive14 is offline
external usenet poster
 
Posts: 10
Default Add-In not Recognized

I wrote a few VBA functions that I want to be able to call from VBA code in
various workbooks instead of putting copies of the code in each VBA workbook.
I put these common functions in a .xla file and stored them in the proper
place (.../microsoft/add-ins). When I open a workbook that wants to use these
common routines I click the checkbox in "tools-add-ins" for the .xla
filename I created.

But when the workbook VBA tries to call the function in the .xla file it
does not recognize that common routine.

Is this the proper use of add-ins and what am I doing wrong.