Forum Discussion
Keeping Certain Constant Information from being Changed/Deleted
Hi, I'm creating an estimation worksheet for painting, and I have certain titles and such that I will never change. I want to know if there's a way to keep all these things from being deleted, but I...
Not quite, but you can do the following:
- Select the entire sheet.
- Press Ctrl+1 to activate the Format Cells dialog.
- Activate the Protection tab.
- Clear the Locked check box.
- Click OK.
- Select all cells that should never be changed.
- Press Ctrl+1 to activate the Format Cells dialog again.
- Activate the Protection tab.
- Tick the Locked check box.
- Click OK.
- Activate the Review tab of the ribbon.
- Click 'Protect Sheet'.
- Use the check boxes to specify what the users will be allowed to do.
- At the very least, leave the 'Select unlocked cells' check box ticked.
- If you want to specify a password that will be needed to unprotect the sheet, enter it in the Password box. Don't forget it.
- Click OK.
- If you specified a password, enter it again as confirmation.
- Save the workbook.