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.
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