Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Conditional Formatting Colors have disappear on my laptop. | Excel Worksheet Functions | |||
Running a macro from a conditional formula | Excel Discussion (Misc queries) | |||
If I have my sheets protected will that prevent me running a macro to hide certain sells? | Excel Worksheet Functions | |||
Conditional Formatting - date ranges | Excel Discussion (Misc queries) | |||
Ranges within Conditional Formatting | Excel Discussion (Misc queries) |