Irishmaninusa,

From the VBA Editor:
Tools/VBA Project Properties
Select the "Protection" tab
Check "Lock Project for Viewing"
Enter the passwords.

Note: An experienced user can circumvent any
passwords if they so desire (including this one).

John

Irishmaninusa wrote:

Hi Everyone,

Is there a way to protect a macro from being changed by people who should
not be changing the way the macro works?

--
J.Daly
structuinteractive
Ph: 616-364-7423
Fx: 616-364-6941

http://www.structureinteractive.com