How to make VBA function “VBA only” and disable it as User defined function

Hi guys,

I have the same question as someone else see:
https://stackoverflow.com/questions/...able-it-as-udf

However in the link, they don't actually have an answer, the closest they have is a "return error if someone tries to use this.", which is not what i am looking for.

I want to make a function that is available to other modules (public), but also does not show up as a function in the worksheet.

(Maybe something to do with Class? Maybe not?)

Thanks!
Jimmy

I depends on from where you want to use the funcion

Insert this line at the top of the module containing the function:
Option Private Module
... which hides the function (ie cannot be used as UDF)
... but function usable from other GENERAL modules

Example - try this
(The sub returns the value of selected cell in a message box, and the function is not visible from the worksheet)

place in MODULE1

Please Login or Register  to view this content.

place in MODULE2

Please Login or Register  to view this content.

When the file containing the above code is open, TestIt can be run from any workbook

I have never heard of a "General" module before, can you please elaborate?

My notes on Option Private Module say:
"Variables are public only within the project they reside."

How do i know what is a project and what is not a project?
How can i group workbooks into projects? (I think that's how it might work?)

I have never heard of a "General" module before, can you please elaborate?

I use the word "General". You may be familiar with the term "Standard". Anyway - they are the same thing

Read this excellent guide from Chip Pearson - it explains the difference between module types.

Originally Posted by JimmyWilliams

How do i know what is a project and what is not a project?
How can i group workbooks into projects? (I think that's how it might work?)

1 workbook = 1 project.

I want to make a function that is available to other modules (public), but also does not show up as a function in the worksheet.

Have you tested the code in post#02?
- it does what you asked