Hello all

I have written an Excel add-in that amongst other things, includes some
custom functions that appear in the "User Defined" category of the Excel
function list. These functions are contained in a separate module within my
add-in.

Is there an easy way (or any way) of making these functions freely & easily
distributable by anyone who uses them WITHOUT requiring that other users get
my add-in. ie, if someone has my add-in, uses some of these custom functions
in a workbook, then wants to send that workbook to somebody else who does
not have my add-in.

They are of course public functions that enhance Excel. They are not for
"internal use" within my add-in.

Hope this makes sense

--

Thanks

Tony McGee
St Agnes Catholic Parish
Port Macquarie NSW 2444
Phone (02) 6588 7444

No. Anyone using the spreadsheet with the UDF's in is is going to need to
have the addin. You run into the same issue with functions from the Analysis
Toolpack. If the user has not installed the toolpack then they can run into
problems...
--
HTH...

Jim Thomlinson


"Tony McGee" wrote:

Hello all

I have written an Excel add-in that amongst other things, includes some
custom functions that appear in the "User Defined" category of the Excel
function list. These functions are contained in a separate module within my
add-in.

Is there an easy way (or any way) of making these functions freely & easily
distributable by anyone who uses them WITHOUT requiring that other users get
my add-in. ie, if someone has my add-in, uses some of these custom functions
in a workbook, then wants to send that workbook to somebody else who does
not have my add-in.

They are of course public functions that enhance Excel. They are not for
"internal use" within my add-in.

Hope this makes sense

--

Thanks

Tony McGee
St Agnes Catholic Parish
Port Macquarie NSW 2444
Phone (02) 6588 7444

You can't "disassociate" the functions from the add-in in which they are
defined. If a workbook utilizes functions in an add-in, all users of that
workbook must have the add-in; without it, they'll get #NAME errors.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"Tony McGee" wrote in message
...
Hello all

I have written an Excel add-in that amongst other things, includes some
custom functions that appear in the "User Defined" category of the Excel
function list. These functions are contained in a separate module within
my add-in.

Is there an easy way (or any way) of making these functions freely &
easily distributable by anyone who uses them WITHOUT requiring that other
users get my add-in. ie, if someone has my add-in, uses some of these
custom functions in a workbook, then wants to send that workbook to
somebody else who does not have my add-in.

They are of course public functions that enhance Excel. They are not for
"internal use" within my add-in.

Hope this makes sense

--

Thanks

Tony McGee
St Agnes Catholic Parish
Port Macquarie NSW 2444
Phone (02) 6588 7444

Chip Pearson wrote:
You can't "disassociate" the functions from the add-in in which they are
defined. If a workbook utilizes functions in an add-in, all users of
that workbook must have the add-in; without it, they'll get #NAME errors.


What am I missing? Can't individual functions be copied and pasted from
an Add-In file module into a workbook general module and be fully usable
in that workbook sent to another user SO LONG AS THE FUNCTION IS
INDEPENDENT OF ANY OTHER FUNCTIONS IN THE ADD-IN?

Alan Beban

Of course you can as long as you have the add-in, it is unprotected or you
know the password.

knut
"Alan Beban" <unavailable skrev i melding
...
Chip Pearson wrote:
You can't "disassociate" the functions from the add-in in which they are
defined. If a workbook utilizes functions in an add-in, all users of that
workbook must have the add-in; without it, they'll get #NAME errors.


What am I missing? Can't individual functions be copied and pasted from
an Add-In file module into a workbook general module and be fully usable
in that workbook sent to another user SO LONG AS THE FUNCTION IS
INDEPENDENT OF ANY OTHER FUNCTIONS IN THE ADD-IN?

Alan Beban

Could you add a method to your addin that exports sharable addin
macros into a VBA module and inserts that module into the current
workbook?

You may have to modify your add-in macros so they can be run as both
add-in macros and workbook macros, that is, by having Workbook and
Worksheet parameters to all the Subs and Functions, but it's not a big
deal.

Check out the Subs and Functions for the VBProject object to get
started.