Thread
:
Conceal functions and subroutines?
View Single Post
#
5
Posted to microsoft.public.excel.programming
Don Guillett[_4_]
external usenet poster
Posts: 2,337
Conceal functions and subroutines?
ALL your woes? You must have a nice life.
glad to help
--
Don Guillett
SalesAid Software
"raj" wrote in message
...
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
"raj" wrote in
message
...
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.
.
Reply With Quote
Don Guillett[_4_]
View Public Profile
Find all posts by Don Guillett[_4_]