Hiding/Locking VBA coding

[sassriverrat]

Good Morning,
As I understand it, you cannot lock/unlock a VBA project with a module. Maybe someone can correct me on this.

Here's what I'm trying to do. I have a hidden sheet that can only be unhidden with a password- I'd like a code (if it can be done) that hides the coding or makes it unable to be easily seen (i.e. 'View Code'- I just turn off the "Developer" tab on most user machines...). Then I'd like to put a button in the hidden Sheet ("Developer") that allows me to quickly access the code myself. The people using this workbook aren't excel friendly AT ALL, but they have a tendency to delete stuff they don't understand...like if they don't understand a formula adding two numbers, they manually type in the answer over top of the formula....it's a headache.

Anyway- thanks for your help. I have two other buttons- one that unprotects all (only the hidden sheet isn't locked) sheets and one that unprotects the workbook.

 

[Yongle]

To password-protect your project look at this

 

[sassriverrat]

So I know how to do it via that method but I was hoping to put a button on a sheet to do it.

 

[Fluff]

Have a look here https://www.mrexcel.com/forum/excel-questions/59402-code-unprotect-vbaproject.html#post276912