Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Make Function Accessible only from VBA
Hi,
I have a few UDFs that should only be callable from VBA (they are meaningless as spreadsheet functions). Does anybody know how to make a UDF invisible to the spreadsheet, but visible to any/all VBA modules? I don't think the "Private" designation is appropriate because it makes the UDF invisible to all other VBA modules. An example of this would be the MsgBox function, which is callable from any VBA module, but not callable directly from a spreadsheet. Thanks in advance for any help. Ryan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
form option buttons - how can I make them accessible? | Excel Discussion (Misc queries) | |||
how do I make a template accessible | Excel Discussion (Misc queries) | |||
Why Would Add-In Modules Not Be Accessible? | Excel Discussion (Misc queries) | |||
How do I make sure my Wkbook is accessible to users using earlier | Excel Discussion (Misc queries) | |||
How do I make a text box accessible in a protected Excel sheet? | Excel Worksheet Functions |