Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Private Module
Have used Option Private Module in all modules with functions to avoid these
functions showing up under the User defined worksheet functions. This worked nicely, but now for some reason all the functions do show again in the UDF category. Any ideas why this could be? RBS |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Private Module
Just ignore this, all solved now.
RBS "RB Smissaert" wrote in message ... Have used Option Private Module in all modules with functions to avoid these functions showing up under the User defined worksheet functions. This worked nicely, but now for some reason all the functions do show again in the UDF category. Any ideas why this could be? RBS |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Private Module
What was happening?
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "RB Smissaert" wrote in message ... Just ignore this, all solved now. RBS "RB Smissaert" wrote in message ... Have used Option Private Module in all modules with functions to avoid these functions showing up under the User defined worksheet functions. This worked nicely, but now for some reason all the functions do show again in the UDF category. Any ideas why this could be? RBS |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Private Module
What was happening was that I made a mistake I had made before.
There is another add-in with similar functions. This didn't have Option Private Module, so all the functions showed up. Simple and silly! RBS "Bob Phillips" wrote in message ... What was happening? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RB Smissaert" wrote in message ... Just ignore this, all solved now. RBS "RB Smissaert" wrote in message ... Have used Option Private Module in all modules with functions to avoid these functions showing up under the User defined worksheet functions. This worked nicely, but now for some reason all the functions do show again in the UDF category. Any ideas why this could be? RBS |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Private Module
Thanks for sharing, I must admit to having been intrigued by your original
'problem' Bob "RB Smissaert" wrote in message ... What was happening was that I made a mistake I had made before. There is another add-in with similar functions. This didn't have Option Private Module, so all the functions showed up. Simple and silly! RBS "Bob Phillips" wrote in message ... What was happening? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RB Smissaert" wrote in message ... Just ignore this, all solved now. RBS "RB Smissaert" wrote in message ... Have used Option Private Module in all modules with functions to avoid these functions showing up under the User defined worksheet functions. This worked nicely, but now for some reason all the functions do show again in the UDF category. Any ideas why this could be? RBS |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Option Private Module
No problem.
Any suggestions about the other post: Application.OnKey etc ? RBS "Bob Phillips" wrote in message ... Thanks for sharing, I must admit to having been intrigued by your original 'problem' Bob "RB Smissaert" wrote in message ... What was happening was that I made a mistake I had made before. There is another add-in with similar functions. This didn't have Option Private Module, so all the functions showed up. Simple and silly! RBS "Bob Phillips" wrote in message ... What was happening? -- HTH Bob Phillips (remove nothere from email address if mailing direct) "RB Smissaert" wrote in message ... Just ignore this, all solved now. RBS "RB Smissaert" wrote in message ... Have used Option Private Module in all modules with functions to avoid these functions showing up under the User defined worksheet functions. This worked nicely, but now for some reason all the functions do show again in the UDF category. Any ideas why this could be? RBS |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Private Sub - Only Accessible from same Module? | Excel Discussion (Misc queries) | |||
Use the Option box value in a module | Excel Programming | |||
Option Private Module not preventing cross project referencing | Excel Programming | |||
private variable: same module, other Sub/Function | Excel Programming | |||
Call Private Function from ThisWorkbook module | Excel Programming |