Add

Option Private Module

to the head of the module. This will make all procedures private to the
project, i.e. any module in the project can use them, other projects (and
Excel) will not see them.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Matthew Wieder" wrote in message
...
Our Automation Add-In has some methods that return object types Excel not
fit
for Excel (one of the methods retunrs a custom collection for example).
Is
there some way to hide this method so the end user won't try and use it as
a
worksheet function, yet have it visible so that it can be used in VBA
where
such objects can be correctly used? As it is, it appears all public
methods
are visible in both VBA and Excel Sheet Functions.