Thread: Hiding AddIn Methods from Worksheet Functions But Exposing to VBA
View Single Post
  #5   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 toVBA
I'm am in an "Automation Add-In" not an Excel VBA Add-In. Managed C#
code available in Excel XP and 2003.

Jim Thomlinson wrote:

At the top of a module you can add

Option Private Module which will keep everything in that module private from
the end user.

If you are in a class check out the bottom of Chip's site here...

http://www.cpearson.com/excel/ClassModules.htm
Reply With QuoteReply With Quote