Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protest sheet but allow sort
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protest sheet but allow sort
You have a reply in .misc
Pete Walburn wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protest sheet but allow sort
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 wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protest sheet but allow sort
Gord,
Yes, I can see that a macro is probably going to do the job better. Thanks, Pete "Gord Dibben" wrote: 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 wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Protest sheet but allow sort
Having similar problem and confirmed suspecions. Thanks.
"Gord Dibben" wrote: 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 wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
lock tab in sheet 2 until cell in sheet one is completed | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
can i sort a protected sheet | Excel Discussion (Misc queries) | |||
way to automaitic sort sheet one numerical, sheet two alpha? | Excel Worksheet Functions | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) |