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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.