MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.

Keely Kasonovitch
RTQM Specialist

Posted by brent on August 08, 2001 1:50 PM

Are you abe to open a blank sheets in the workbook and =+Sheet1!$A$1:$?$? or link the protected worksheets to unprotected worksheets, wherein you can perform sorting?

Posted by Connie on August 09, 2001 12:47 PM

I use XL2000, and it isn't possible to sort protected unless you use a macro. I know this question has been asked many times on this board, so if you'll search the archives, you're highly likely to find quite a few macro alternatives. If you can't use macros (i.e. against company policy, etc), then you might be out of luck.