sorting locked cells


D

dave

Is there a way to sort locked cells in a protected worksheet so that a user
can sort cells but cannot input data in certain cells?
 
Ad

Advertisements

Y

YESHWANT JOSHI

if u r using office 2003, there is a way out there.

before protecting the sheet, kindly select the "sort" button there at the
time of giving password first time (protect sheet title)

click yes, if it works
 
Ad

Advertisements

K

Kooljay2

I am trying to do this also. I am using 2003, and I check the box "Sort" when
protecting the worksheet, but I am not able to sort the sheet. I do not want
to unlock the cells to allow input. If I turn on AutoFilter and allow users
to use AutoFilter and Sort when I protect the sheet, I can use AutoFilter to
filter for specific items but not to Sort. Any help will be greatly
appreciated.
 

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