Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conceal worksheets | Excel Discussion (Misc queries) | |||
turn off subroutines | Excel Discussion (Misc queries) | |||
How do I conceal the unused range from the scroll bar? | Excel Discussion (Misc queries) | |||
Duplicate Subroutines | Excel Programming | |||
Run method for subroutines | Excel Programming |