ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Automatic Cell Protection by Colour? (https://www.excelbanter.com/excel-discussion-misc-queries/120845-automatic-cell-protection-colour.html)

Bert Christy

Automatic Cell Protection by Colour?
 
Could anyone tell me if it is possible to lock a number of cells in a number
of different sheets within a workbook, by specifying the colour of the cells
(already formatted/coloured) i.e. lock all red cells whilst leaving green
cells unlocked for data entry?
--
Bert


All times are GMT +1. The time now is 12:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com