Any kind of argument, eg a boolean:
Public MySub(optional dummy as boolean)

HTH
--
AP

"Matthew Wieder" a écrit dans le
message de news: ...
Making the method private hides it from VBA as well since it doesn't get
registed by COM so that won't work. What type of 'dummy argument' would
stop a method in an Automation Add-In from being shown as executable?

Ardus Petus wrote:
Either turn the Sub to Private,
or create a dummy argument that will keep it from being shown as
executable.

HTH
--
AP

"Matthew Wieder" a écrit dans
le message de news: ...

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.