| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple functions, conditional functions | Excel Worksheet Functions | |||
| How to convert cell formula functions to code functions | Excel Discussion (Misc queries) | |||
| formula/functions for average and if functions | Excel Worksheet Functions | |||
| efficiency: database functions vs. math functions vs. array formula | Excel Discussion (Misc queries) | |||
| excel functions and User defined functions | Excel Programming | |||
Linear Mode
