| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Security level of protected sheets
Not sure if this belongs in this group, but anyway..
I have protected a sheet, but I would like the user to be able to shade cells, and have some level of editorial allowance. I'm sure I've seen a dialog box before which allowed me to let the user do certain things, but I can't find it. I'm using excel 2000. Cheers Tony |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Security level of protected sheets
Unprotect the sheet and then protect it again. As you protect it you will get
the dialog that allows you to assign user priveleges to a protected sheet. Mike "bony_tony" wrote: Not sure if this belongs in this group, but anyway.. I have protected a sheet, but I would like the user to be able to shade cells, and have some level of editorial allowance. I'm sure I've seen a dialog box before which allowed me to let the user do certain things, but I can't find it. I'm using excel 2000. Cheers Tony |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Security level of protected sheets
You saw that enhanced dialog in xl2002+.
xl2k doesn't support this. bony_tony wrote: Not sure if this belongs in this group, but anyway.. I have protected a sheet, but I would like the user to be able to shade cells, and have some level of editorial allowance. I'm sure I've seen a dialog box before which allowed me to let the user do certain things, but I can't find it. I'm using excel 2000. Cheers Tony -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing Security Level in Excel | Excel Discussion (Misc queries) | |||
| Not able to KEEP Macro Security Level At Minimum | Excel Discussion (Misc queries) | |||
| Macro security level in excel will not change | Excel Discussion (Misc queries) | |||
| Protected Sheets or other security | Excel Discussion (Misc queries) | |||
| Setting macro security level to "low" permanently? | Excel Discussion (Misc queries) | |||
Linear Mode
