sorting locked cells

  • Thread starter Thread starter dave
  • Start date Start date
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?
 
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
 
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.
 
You must log in or register to reply here.

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
Merging Cells and Sorting 1
Lock format but allow data entry 1
Locked Property off, but cannot select cell 3
Locking cells with formula 1
Sorting a Protected Worksheet 1
Sorting while protected - this question may not have been covered. 1

Back
Top