Password Protect Excel 2007 Worksheet. How to configure a number of cell ranges to allow people to edit one range. Worksheet protection is a two-step process: the first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password.
For many years, sheet protection seemed geared towards. Now we are going to password protect our entire worksheet. Microsoft Excel's worksheet password protection options have been known to trip people up from time to time.
Protecting a worksheet or cell range can save you a lot of headaches.
Worksheet protection is a two-step process: the first step is to unlock cells that others can edit, and then you can protect the worksheet with or without a password.
There have been a few references online to some internal coding (VBA?) that might be a solution, but the directions I've seen aren't very clear. The Excel application will ask if you want to enable or disable Macros. The advantage to this approach is that you have two levels of passwords—one for the range (columns E and J) and one for the worksheet as a whole.