23cp
05-07-2010, 09:47 PM
Hi. I am using Excel 2007. I know that Excel offers security passwords for various steps: 1- accessing file (reading and writing), 2- sheet protection, 3- workbook protection, and 4- VBA code and project. The security level is much better for accessing file than for the others (I read they could be easily cracked if you know how).
Various people will be accessing my file, so file protection is not my issue. I need that the others steps, especially the VBA code, could not be accessible, even for a pro with knowledge or "brute force". Is there any way to secure the passwords of sheet protection, workbook protection and VBA project protection, when someone has access to the file?
If no password can be secured, is it possible to disable the VBA window so when someone try to access that window (even from another workbook), the VBA window would stay not visible or disactivated as long as my file is open? The same for the sheet protection and workbook protection, is it possible to disable the access to these capabilities so no one could try to crack the passwords? Thanks.
Various people will be accessing my file, so file protection is not my issue. I need that the others steps, especially the VBA code, could not be accessible, even for a pro with knowledge or "brute force". Is there any way to secure the passwords of sheet protection, workbook protection and VBA project protection, when someone has access to the file?
If no password can be secured, is it possible to disable the VBA window so when someone try to access that window (even from another workbook), the VBA window would stay not visible or disactivated as long as my file is open? The same for the sheet protection and workbook protection, is it possible to disable the access to these capabilities so no one could try to crack the passwords? Thanks.