|
|
#4
02-27-2011, 01:03 PM
|
|||
|
|||
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:
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. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 Protecting or hiding ASK fields
|
SaneMan | Word | 1 | 01-14-2011 08:16 PM |
|
IF Formulas
|
mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |
|
Protecting your logo in Word
|
TimD | Word | 5 | 04-29-2010 07:10 AM |
|
Protecting image in word 2007.
|
aligahk06 | Word | 1 | 10-12-2009 08:22 AM |
| Protecting Word Document by restricting access permissions! | user | Word | 0 | 11-20-2008 01:21 PM |
Windows 7 
Office 2010 (Version 14.0)
Threaded Mode