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.

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

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