Protest sheet but allow sort

[Guest]

Hi,

I have a spreadsheet that I would like to protect but still allow users to
sort and filter.
In Tools, Protect Sheet, I enter a password to unprotect sheet and put a
tick in the checkbox for Allow all users of this worksheet to: Sort.

But when I try to sort a column, I am told that the sheet is protected and I
cannot sort.

How do I get this to work?

Pete

 

[Dave Peterson]

You have a reply in .misc

Hi,

I have a spreadsheet that I would like to protect but still allow users to
sort and filter.
In Tools, Protect Sheet, I enter a password to unprotect sheet and put a
tick in the checkbox for Allow all users of this worksheet to: Sort.

But when I try to sort a column, I am told that the sheet is protected and I
cannot sort.

How do I get this to work?

Pete

 

[Gord Dibben]

Pete

Prior to protecting the sheet the column(s) to sort must be unlocked.

Any Autofilter must be applied prior to protecting the sheet.

You may be better off using a macro to unprotect, do the sort, then
re-protect.


Gord Dibben Excel MVP


On Mon, 28 Nov 2005 02:00:03 -0800, Pete Walburn <Pete

 

[Guest]

Gord,

Yes, I can see that a macro is probably going to do the job better. Thanks,

Pete

 

[Guest]

Having similar problem and confirmed suspecions. Thanks.