How do I protect my Macros from unwanted edits

[Steverizer]

I have a worksheet with several macros that I want to distribute to colleagues for their use in pricing decisions. I have protected the owrkbook and each of the sheets, but I can still gain access to the macros for view and edit. How can I block this access by others?

[jeffreybrown]

You need to protect the VBA project...

Alt +F11 >> Visual Basic Editor >> Tools >> VBAProject Properties >> Protection tab
Check Lock Project for Viewing and enter a password twice

[J450n]

In the IDE (alt + F11) goto Tools>VBAProject-Project Properties>Protection[TAB] and set a password