Hi Peter:

Thanks for the info. Could you explain a bit more about creating a
reference to the Addin via a Tools reference? Is this different than
installing and enabling the Addin? The Excel 2007 Help system isn't exactly
a user-friendly platform.

Thanks again!

Jon

UDF's in an addin can be used in cell formulas as you describe.

However, if you want code in your project to call a procedure in an addin
there are two ways

1. Set a reference in your project to the addin project via Tools
references

2. result = Application.Run("myAddin.xla!myFunc", arg1)
or call Application.Run("myAddin.xla!mySub", arg1)

Regards,
Peter T

Hi all:

I'm having a lot of trouble accessing Sub routines in an Addin from a
worksheet. For some reason, I can access the any Functions just fine
like
so:

=AddinFunctionName()

But, I cannot access similar Subs with what I thought was the correct
syntax:

AddinSubName

When I try the latter, I get a compiler error.

ANY help will be greatly appreciated!

Thanks!

Jon