Before enabling sheet protection, unlock any cells they should have access to. This is on the Protection tab of the Format Cells dialog box.
After I click Protect Sheet, I cannot change any formatting on the sheet at all. I can only edit the content of cells that have been unlocked.
Regarding
Quote:
one option under the protect sheet icon and that brings up the protect sheet dialogue box. This does not offer any options for protection of formatting
|
:
When you click Protect Sheet, don't you get a list of things you can choose to allow the user to do, and Format Cells is one of them? Do not check the box for Format Cells and they won't be able to change your formats.