| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell color index comparison | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
| Can't open doc. Too many different cell formats. | Excel Discussion (Misc queries) | |||
| How do I find out how many different cell formats an existing wor. | Excel Discussion (Misc queries) | |||
Linear Mode
