[SOLVED] 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?

HTH

[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.








"Bearacade" wrote:

>
> Have you tried:
>
> Tools > VBAProject Properties > Protection?
>
> HTH
>
>
> --
> Bearacade
>
>
> ------------------------------------------------------------------------
> Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016
> View this thread: http://www.excelforum.com/showthread...hreadid=556228
>
>