PDA

View Full Version : Solved: securing Vb from users



rodney_malod
01-16-2006, 07:52 AM
Hi is it possible to set VB so that users of a sheet cant break in and edit my code?

cheers!

Killian
01-16-2006, 08:09 AM
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
01-16-2006, 08:09 AM
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
01-16-2006, 08:12 AM
cheers people!

geekgirlau
01-16-2006, 05:10 PM
Don't forget to mark this thread as "Solved" using the Thread Tools option at the top of the window.