ExcelBanter - Allowing sort of protected cells

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Allowing sort of protected cells (https://www.excelbanter.com/excel-worksheet-functions/237929-allowing-sort-protected-cells.html)

albie60

Allowing sort of protected cells

I have data within certain cells I want to protect but I also want to allow
sorting of those same cells. In other words, I want to allow users to sort
ALL cells (protected and unprotected) but restrict them from changing the
values of of the protected cells. I can't seem to find an answer.

Dave Peterson

Allowing sort of protected cells

Maybe you could provide a macro that unprotects the sheet, sorts the data,
reprotects the sheet.

albie60 wrote:

I have data within certain cells I want to protect but I also want to allow
sorting of those same cells. In other words, I want to allow users to sort
ALL cells (protected and unprotected) but restrict them from changing the
values of of the protected cells. I can't seem to find an answer.

--

Dave Peterson

All times are GMT +1. The time now is 08:33 PM.