View Single Post
  #1   Report Post  
Posted to microsoft.public.dotnet.framework.interop,microsoft.public.excel.programming
Matthew Wieder[_3_] Matthew Wieder[_3_] is offline
external usenet poster
 
Posts: 30
Default Hiding AddIn Methods from Worksheet Functions But Exposing to VBA

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.