How doe I protect user defined functions in VB Editor

[jbowering]

I have created several user defined functions using the Tools/Macro/Visual
Basic Editor. How can I secure those formulas from tampering by users.

Thanks.

 

[Bearacade]

Have you tried:

Tools > VBAProject Properties > Protection?

HT

 

[jbowering]

Thanks Bearacade.

I did try the Project options, but it didn't work. I have the "Lock project
for viewing box checked and have set a password. I saved, then closed down.

I expected that the next time I open VB Editor, I would get prompted for the
password. This did not happen. Is there some place else where I need to
activate password protection?

Thanks again.