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 October 10th 06 01:19 AM

how to only protect/lock cell formats?

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,


All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.