I want to protect a worksheet, leaving some cells unlocked for others to edit, and have others be able to sort elements in the worksheet. Even selecting "Sort" as an option when checking Protect Sheet doesn't enable sorting. Any suggestions?
I want to protect a worksheet, leaving some cells unlocked for others to edit, and have others be able to sort elements in the worksheet. Even selecting "Sort" as an option when checking Protect Sheet doesn't enable sorting. Any suggestions?
Hi LeeL,
Welcome to ExcelFox!!
The Sort will only be allowed on the unprotected cells. A macro can be used to sort the range (including locked cells). If you interested, attach the workbook here.
Cheers !
Excel Range to BBCode Table
Use Social Networking Tools If You Like the Answers !
Message to Cross Posters
@ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
Posting Permissions
Reply With Quote
Bookmarks