Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Protection, Allow Sorting
This seems like a really old question, but I just can't figure it out...12
hours later. Spell it out for me please... I have a spreadsheet with a pretty header, column headers, and want to protect my document from data being changed only, but allow for sorting data (all columns) within range B6:M284. Give it to me as if I were in kindergarten...I'm not getting it! Thanks in advance for any help. You will be my hero if it works! Lucy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sheet Protection, Allow Sorting
Lucy
I don't think you're missing anything. The range to be sorted must be unlocked before protecting the sheet. i.e. B6:M284 must be unlocked. Excel help is little fuzzy on this point. Best method is to use a macro which unprotects, sorts and re-protects. Gord Dibben MS Excel MVP On Mon, 6 Nov 2006 15:44:01 -0800, Lucy wrote: This seems like a really old question, but I just can't figure it out...12 hours later. Spell it out for me please... I have a spreadsheet with a pretty header, column headers, and want to protect my document from data being changed only, but allow for sorting data (all columns) within range B6:M284. Give it to me as if I were in kindergarten...I'm not getting it! Thanks in advance for any help. You will be my hero if it works! Lucy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem created by sorting linked sheet | Excel Discussion (Misc queries) | |||
Sorting List to a new sheet | Excel Worksheet Functions | |||
sorting master sheet messes up cells in other sheets linked to it | Excel Worksheet Functions | |||
Using a relative SHEET reference for source data in a chart | Charts and Charting in Excel | |||
Naming & renaming a sheet tab | Excel Worksheet Functions |