Excel 2007 VBA - Password Protecting 1

[BGumm]

Can anyone tell me if it's possible and, if so, how to password-protect all VBA in a given project so as to block users from being able to meddle?

A common task, I'm sure, but I've never had to even think about doing it before as most of my Excel VBA has been for me or my immediate reports.

Thanks!

 

[ettienne]

That is going to be difficult, let me see:
In Excel click Tools, Macro, VBE
In VBE click Tools, VBAProject Properties, Protection, Lock project for viewing and enter a password.

 

[BGumm]

Thanks for the response! I especially appreciate the free sarcasm & belittling you included. Much appreciated.