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

Similar Threads

Enabling Autofilter and Sorting in a Protected Sheet 2
Protecting a Sheet 7
Locked Property off, but cannot select cell 3
Sorting while protected - this question may not have been covered. 1
Locked worksheet & hyperlinks (w/ select locked cells unchecked) 1
Sorting a Protected Worksheet 1
copy cells but lock editing 5
corrupted formula in protected worksheet 21

Top