• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Multiple conditional formatting with Allow Users To Edit Ranges feature

A

a4vtt

New Member
Hello,


Mr. Hui in this forum used to help me with the VB coding for 4 (or more) conditional formattings. It worked very well.


However, after I applied the "Allow Users to Edit Ranges" feature to protect some parts of the Excel sheet, the code displayed error messages when debugging.


I hope Hui will come back to this forum to help me again or if any expert here who knows how to resolve this problem, please help me.


Thank you very much!
 
a4vtt


You may need to add the following lines into the macro


after the first line add


ActiveSheet.Unprotect


and before the last line 'End Sub' add


ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
 
You must log in or register to reply here.
Back
Top