| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locked Cells Sorting
I have a sheet with a Range of A1:n2500. A1 to N1 are headers. I want to sort
the A2:N2500 data based on the header in C1. Some of the cells are locked because I have formulas and dont want anyone to change these, and some are unlocked. When I protect the sheet I check sort and selected unlocked cells. When I go to srt, I get an error that Excel cant sort based on locked cells. Anyone that can help me on this, or suggest an alternative VBA code. I am not real up on VBA. Thanks, For any help |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linking Groups of cells between workbooks | Excel Discussion (Misc queries) | |||
| Excel locked cells | Excel Discussion (Misc queries) | |||
| checking that cells have a value before the workbook will close | Excel Worksheet Functions | |||
| import with locked cells? | Excel Worksheet Functions | |||
| Problem sorting cells containing hyperlinks | Excel Worksheet Functions | |||
Threaded Mode
