A common example is Locking formula cells to prevent inadvertent erasure or modification of formulas. So, does this mean that Excel worksheet protection is absolutely pointless? Not at all! It makes sense to lock Excel sheets to avoid accidental changes in the sheet contents. In other words, if someone really wants to get access to a protected sheet, they will. The recent versions of Excel use more sophisticated methods of sheet protection, but they are also vulnerable and can be unlocked without knowing a password. Anyone who has at least some basic knowledge of VBA can crack it in minutes (here's an example of the VBA code that easily cracks passwords in Excel 2010 and lower). In older versions (below Microsoft Excel 2010), it doesn't even matter how long and complex your password is.
Even when you protect your Excel worksheet with a password, that password is very easy to break. Why? Because Microsoft Excel uses a very simple encryption algorithm for worksheet protection. It's is not actually intended to prevent people from accessing data in a password-protected worksheet. Worksheet protection in Excel is not a security feature. What you need to know about Excel worksheet protection
0 kommentar(er)
