Hi! is there anyway for me to lock the macro that i have created? so that only me can edit/modify it? any inputs will be greatly appreciated.
Printable View
Hi! is there anyway for me to lock the macro that i have created? so that only me can edit/modify it? any inputs will be greatly appreciated.
You can lock the vba project file with a password. Its not 100% secure but work very well.
Go to your VBA IDE (Alt+F11) and click on the menu - Tools > VBAProject Properties > Protection tab > check "Lock project for viewing" and enter in a password, re-enter it and click OK. Close your program and reopen it, press Alt+F11 and try to view your VBAProject. :D
ok thanks!!!