Security level of protected sheets

  • Thread starter Thread starter bony_tony
  • Start date Start date
B

bony_tony

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Protect sheet but be able to merge cells 1
hide columns on a protected sheet 2
using Spell check on protected sheet 6
Merging cells in a Protected Sheet 2
Three levels of protection in one worksheet 1
INDIRECT with Sheet Level Defined Name 2
Protecting Sheets with drop down boxes 1
Change cell color in protected sheet 1

Back
Top