I'm assisting with a workbook that has a LOT of conditional formats and they
are being overwritten. Has anyone come up with a fool proof way to prevent
this? Unfortunately, they are in cells that can't be locked.

Thanks,

Barb Reinhardt

I sometimes write macros to auto restore formulas that end users delete.
Same idea...

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Barb Reinhardt" wrote in message
...
I'm assisting with a workbook that has a LOT of conditional formats and
they
are being overwritten. Has anyone come up with a fool proof way to
prevent
this? Unfortunately, they are in cells that can't be locked.

Thanks,

Barb Reinhardt

I'm testing the "Target" for conditional formats and formulas in the
Worksheet_SelectionChange event and acting on what's found in the Worksheet
change event. I wish I didn't have to do that, but I do.

Barb Reinhardt



"Don Guillett" wrote:

I sometimes write macros to auto restore formulas that end users delete.
Same idea...

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Barb Reinhardt" wrote in message
...
I'm assisting with a workbook that has a LOT of conditional formats and
they
are being overwritten. Has anyone come up with a fool proof way to
prevent
this? Unfortunately, they are in cells that can't be locked.

Thanks,

Barb Reinhardt


.