Hi all,
Whats the best way to protect VBA code from being seen or altered. Right now the workbook is protected but is there a way to hide/secure the code from being altered?
thanks
Hi all,
Whats the best way to protect VBA code from being seen or altered. Right now the workbook is protected but is there a way to hide/secure the code from being altered?
thanks
gimli,
Open your workbook
Press the keys ALT + F11 to open the Visual Basic Editor
Click on Tools
VBAProjectProperties...
Click on the Protection tab
Click in the box for Lock project for viewing
In the Password to view project properties box
Enter a password in the two boxes for Password, and Confirm password
Click on the OK button
Do not forget your password, and save your workbook.
Ahhh excellent! Thanks much
Excel's protection is very basic, and easily broken, so the harsh reality is this - Just who are you "protecting the workbook from"?
There far too many commercial products currently available, which break protection. So if someone has a will to do so, then it'll be done. Protection is something that Microsoft has been unable to come to grips with at this point.
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Its for intra company use only..not a large threat. Just wana make sure that curious people cant change stuff on purpose or by accident...
So I think the basic protection will be just fine.
thanks much