Hi Kathy,

In the visual basic editor (Alt + F11)
From the menus select "Tools/VbaProject Properties
Select "Protection" at top
Select "Lock Project for Viewing" check box
Enter a password twice and click "Okay"
Save the workbook and next time you open it the Vba is protected.

Regards, Rocky McKinley


"Kathy Goldie" wrote in message
...
Can you protect a macro so a user can not change or
delete it