Posted to microsoft.public.excel.programming

RB Smissaert RB Smissaert is offline

external usenet poster

Posts: 2,452

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Private Sub - Only Accessible from same Module?	pallaver	Excel Discussion (Misc queries)	1	July 8th 08 02:57 PM
Use the Option box value in a module	Tempy	Excel Programming	2	September 16th 05 06:47 PM
Option Private Module not preventing cross project referencing	seisman	Excel Programming	2	July 29th 05 03:24 PM
private variable: same module, other Sub/Function	Stefi	Excel Programming	4	July 5th 05 09:10 AM
Call Private Function from ThisWorkbook module	Beto[_3_]	Excel Programming	3	February 25th 04 01:36 PM

All times are GMT +1. The time now is 06:48 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us