| 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 |
| 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) | |||
Threaded Mode
