Protecting a Worksheet but ability to Sort

T

Toni

Does anyone know if you can protect a worksheet so other
users cannot change the contents of the cells, but still
allow them to sort the worksheet? I have tried everything
to get this to work, but to no avail.

Thank you,

Toni
 
D

Dave Peterson

Maybe you could put a button from the forms toolbar on the worksheet. Assign a
macro to that button that

1. unprotects the worksheet
2. sorts the data
3. reprotects the worksheet
 
A

Arawn

Well, you could write a macro that unprotects the sheet, sorts a
specified range, and then re-protects the sheet.
 
A

Alana

Toni,
This is the quick fix I usually use. It is not the best, and may not work
in your situation, but if you haven't used macros before it will be easier.
It's only really feasible if you don't have a large number of tabs
(worksheets) in your workbook, or if you only want to sort a couple of them.

Copy the worksheet to another tab and sort it the way you think your users
will need it sorted. Be sure to label your tabs so the user knows how you
sorted things. Then protect the document.
 
Top