LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.dotnet.framework.interop,microsoft.public.excel.programming
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Hiding/Exposing Rows based on a cell value Tami Excel Worksheet Functions 10 July 11th 09 02:03 PM
Using IF functions to calculate shipping cost and methods jjlandrum Excel Worksheet Functions 1 March 12th 08 04:48 PM
Hiding Methods in Automation Add-In Matthew Wieder[_3_] Excel Programming 3 June 23rd 06 02:53 PM
Hiding/Exposing Worksheets based on a Number Entry David Excel Discussion (Misc queries) 6 December 11th 05 02:40 AM
raw speed for excel worksheet functions? - xll -or com addin? John Doe[_3_] Excel Programming 1 August 18th 03 11:26 PM


All times are GMT +1. The time now is 11:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"