How to Sort Protected Worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a protected worksheet and I am trying to allow sorting and formating,
but not deleting or inserting. It does not work the way it should. Does
anyone know the trick? I know about give a range of to edit, but how can I
allow users to sort the data without being able to corrupt the data?
 
Good morning MrLord

Why not have a "sort" button on the worksheet that is linked to a
macro. The macro (which should be easy enough to record) will
unprotect the sheet, sort the data and then reprotect the sheet again.

HTH

DominicB
 
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

Protecting Excel Formulas 2
allow a user to edit ranges in a protected worksheet 3
How to sort protected worksheet in Excel 07? Doesn't work. 1
SORT DATA ON A PROTECTED WORKSHEET! 2
Sorting Protected Worksheet 4
Sorting a protected worksheet 4
Allowing sort of protected cells 1
Is autofilter & sort disabled in protected cells? 1

Back
Top