Monday, January 31, 2005

Protection in Excel Spreadsheets

I generally look at up to 4 levels of security on an Excel file.
At the end of the day there really isn't a heck of a lot of security for those who know how to remove protection from files. However for general users who are unaware of this here is how I do it.
The first level of secuirity is to make a file read only, and require a password to open or access the file.
The second is to require another password to modify the file.
Third inside the file you can have various levels of protection controlled by macros. Lock the entire file up and then require users to use password controlled macros to unlock various portions of the file.
Fourth allow access to the whole file with a master password (or use the vba project password to inhibit access to the macros).
I will provide the VBA code for the password protection (third level) macros later.