View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones[_2_] Norman Jones[_2_] is offline
external usenet poster
 
Posts: 421
Default Hide automation add-in functions

Hi Shahin,

Try using the statement:

Option Private Module

at the head of the module, before any
procedures.


---
Regards.
Norman


"Shahin Musayev" wrote in message
...
Hi everyone!

I'm developing excel automation add-in and I want some of my functions
to be callable from worksheet but do not appear in "Insert Function"
dialog.

I can see two possibilities:

1) somehow hide functions;
2) move functions that should be hidden to separate class and then
somehow hide corresponding functions category.

Is this possible?

Thanx,
Shahin