Sorting protected worksheets


G

Guest

Greetings!

I need to allow others to sort my worksheet which contain a few protected
columns. I am also using setup data validation and several other functions.
This file is stored on a shared drive.

So farI have tried the following:

Tools/protection/protect sheets
Select locked cells
select unlocked cells
select format cell,
select columns
select rows
SELECT SORT
Select Autofilter
Select pivot reports

Whenever other users attempt to sort this worksheets, they get a message
stating this worksheet is protected.

By selecting the "SELECT SORT" option listed above, shouldn't they be able
to sort this data?

Thanks for your help.
Drr
 
Ad

Advertisements


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