Quote:
Originally Posted by melvin1942
Do you need to lock the cells before you protect the sheet, or protect the sheet and then lock the cells?
|
Step 1: Set cell formats (check/uncheck Locked and/or Hidden on cell Protection tab)
Step 2: Protect sheet (when you want for users restrict removing protection, then with password - but don't then forget it).