View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default 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