View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] hermac@telenet.be is offline
external usenet poster
 
Posts: 5
Default Same function in add-in and workbook module

I have an add-in with several UDFs. If I copy one or more of these
functions to a workbook module , I seem to get no trouble calling such
function in that workbook. It also seems that the function which is
actually used then is the one in the workbook, not the one in the add-
in.
The reason for doing so is that I want to distribute the workbook to
other people with only the copied UDFs and without the whole add-in.
I want to keep that workbook on my own computer as well , thus having
the same UDF twice.
Is this sound practice or should I expect trouble?
Thanks for your advice.
Herman