Hi is it possible to set VB so that users of a sheet cant break in and edit my code?
cheers!
Hi is it possible to set VB so that users of a sheet cant break in and edit my code?
cheers!
In the VBE, select Tools>VBAProject properties and on the protection tab, check "Lock project for viewing" and set a password.
It's not the last word in high security - a determined individual will always find a way but it's enough to deter most users.
K :-)
Hello there,
No, it's not possible. You can slow some people down though by putting a password on your VBA project. To do so ..
Alt + F11
Tools | VBA Project Properties | Protection (tab)
Enter password, confirm password, ensure you check the box "Lock project for viewing".
Note that the password will not apply until you save/close/reopen the workbook.
Regards, Zack Barresse
Check out the KB! :|: BOARD TAGS: WHAT ARE THEY AND HOW DO I USE THEM
What is a Microsoft MVP? | Free Microsoft Courses | My Book on Excel Tables
cheers people!
Don't forget to mark this thread as "Solved" using the Thread Tools option at the top of the window.