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.

In the VBE: ToolsReferences, check the add-in

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"naive14" wrote in message ...
|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.
|

That's great. Thank you.

"Niek Otten" wrote:

In the VBE: ToolsReferences, check the add-in

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"naive14" wrote in message ...
|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.
|