Sorting in a protected sheet
Posted by Keely on August 08, 2001 12:50 PM
I have a workbook in which a large range of cells containing a 3 line formula need to be protected to save potential headaches. I also need to be able to sort the data on each sheet. I am unable to locate information on if it CAN be done, and if so, how to do it. I know that to keep the cells from being modified that they have to be marked as both Hidden and Locked. The cells that the sort are based off of are fully able to be modified. Even if only one column in the sheet is selected, the sort option is grayed out.
Unfortunately, I am unable to publish or disclose the specifics of the workbook.
If anyone has any ideas, or can point me in the right direction, it would be much appreciated. You can reach me at the below e-mail address.