security - protecting a worksheet


P

paulas

I have protected worksheets that I need users to update. (I unlocked the
cells that I want them to use and kept the rest locked; then protected it.)
When certain sheets are activated, I want them to be sorted but excel will
not allow it once I protect the sheets. I unchecked the "sort" button in the
security box but it still will not allow the sort. (I also tried allowing
insert rows and columns and it's as if I didn't bother.) Am I doing this
wrong somehow or misinterpreting what these buttons allow? HELP!!
Thanks!
Paula
 
Ad

Advertisements

Ad

Advertisements

P

paulas

From what I've been reading, if any cell in the sheet is "locked", you cannot
sort at all. I don't understand this but it seems to be the case. Thanks!
 

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

Top