Functions not Functions
 

I'm using VB code written to connect Excel to a database. It contains
several "Delcare Function" statements. All of these show up in the User
Defined Functions dropdown list in the worksheet. How can I remove these
from this list?

Functions not Functions
 

Change them from Public to Private functions (if they are not declared as
being either private or public then they are public by default and you need
to add private). This may have a down strem effect on your code if the code
in other module uses these functions.
--
HTH...

Jim Thomlinson


"T" wrote:

I'm using VB code written to connect Excel to a database. It contains
several "Delcare Function" statements. All of these show up in the User
Defined Functions dropdown list in the worksheet. How can I remove these
from this list?

Functions not Functions
 

Thanks very much!

"Jim Thomlinson" wrote:

Change them from Public to Private functions (if they are not declared as
being either private or public then they are public by default and you need
to add private). This may have a down strem effect on your code if the code
in other module uses these functions.
--
HTH...

Jim Thomlinson


"T" wrote:

I'm using VB code written to connect Excel to a database. It contains
several "Delcare Function" statements. All of these show up in the User
Defined Functions dropdown list in the worksheet. How can I remove these
from this list?