ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how to only protect/lock cell formats? (https://www.excelbanter.com/excel-discussion-misc-queries/113533-how-only-protect-lock-cell-formats.html)

Glen

how to only protect/lock cell formats?
 
Hi,

I have a spreadsheet with an area for others to enter data. Formating in
this area is controlled by a bunch of conditional formats.

Is there a simple way to permit changes to the contents of the cell but that
prevents changes to the formats when users either use "Clear All" or cut data
and paste elsewhere?

The spreadsheet needs to remain free of macros/scripts.

Thanks in advance,

Glen


All times are GMT +1. The time now is 08:59 AM.

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