I have conditional formatting and protected ranges set up in an Excel 2003 workbook. When I run a particular macro, the conditional formatting and protected ranges disappear after the macro is done running. The conditional formatting is completely gone and the entire workbook becomes protected.
The line in the
VB code related to the protection is:
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
But I don’t think anywhere in the code references the conditional formatting. Please help!!