View Single Post
  #1   Report Post  
CNP CNP is offline
Junior Member
 
Posts: 2
Default Conditional Formatting & Protected Ranges disappear after running macro

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!!