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

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

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