Solved: securing Vb from users

[rodney_malod]

Hi is it possible to set VB so that users of a sheet cant break in and edit my code?

cheers!

[Killian]

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.

[Zack Barresse]

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.

[rodney_malod]

cheers people!

[geekgirlau]

Don't forget to mark this thread as "Solved" using the Thread Tools option at the top of the window.