Conceal functions and subroutines?

[raj]

Hello and please help a novice if possible.

I have programs consisting of many functions and
subroutines located in several different modules within a
file.

When a user clicks the fx (function button) on the
toolbar, all my functions show up in the list of available
functions. Also, my subroutines show up in the list of
macros when the user menus to [Tools][Macro][Macros].

Please note that I can't use "Private" at the function or
subroutine level because I need to make calls across
modules. How can I overcome this? Or do I need to change
the structure of my code altogether?

Your assistance and/or example code would be most
appreciated. Thanks in advance.

 

[Seth]

At the top of each module add this line of code:

Option Private Module

Seth

 

[Don Guillett]

try adding the line
option private module as the TOP line in a module.

 

[raj]

You both just took care of all my woes!

Thank you to all.

-----Original Message-----
try adding the line
option private module as the TOP line in a module.

--
Don Guillett
SalesAid Software
(e-mail address removed)

Hello and please help a novice if possible.

I have programs consisting of many functions and
subroutines located in several different modules within a
file.

When a user clicks the fx (function button) on the
toolbar, all my functions show up in the list of available
functions. Also, my subroutines show up in the list of
macros when the user menus to [Tools][Macro][Macros].

Please note that I can't use "Private" at the function or
subroutine level because I need to make calls across
modules. How can I overcome this? Or do I need to change
the structure of my code altogether?

Your assistance and/or example code would be most
appreciated. Thanks in advance.

.

 

[Don Guillett]

ALL your woes? You must have a nice life.
glad to help

--
Don Guillett
SalesAid Software
(e-mail address removed)

You both just took care of all my woes!

Thank you to all.

-----Original Message-----
try adding the line
option private module as the TOP line in a module.

--
Don Guillett
SalesAid Software
(e-mail address removed)

Hello and please help a novice if possible.

I have programs consisting of many functions and
subroutines located in several different modules within a
file.

When a user clicks the fx (function button) on the
toolbar, all my functions show up in the list of available
functions. Also, my subroutines show up in the list of
macros when the user menus to [Tools][Macro][Macros].

Please note that I can't use "Private" at the function or
subroutine level because I need to make calls across
modules. How can I overcome this? Or do I need to change
the structure of my code altogether?

Your assistance and/or example code would be most
appreciated. Thanks in advance.

.