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