Macro does not work in Protected Worksheet

I have a macro in my worksheet that highlights any cell where a change has been made. Below is the macro:

Please Login or Register  to view this content.

End Sub


.....When I protect the worksheet and lock certain cells from being touched, the macro stops working and an error pops up, asking if I wish to debug. There are certain ranges in the worksheet that can be touched but even when I make a change within those ranges, the error pops up for debugging.

When I continue to debug it, the following portion of the macro is highlighted: Target.Interior.Color = 13434879

Can you please advise how to run this macro in a protected worksheet?

Also, if I only wanted to apply it to a certain range of the worksheet, how would this be done?

Thank you in advance for the advice and help!

Best,
Nathaly Renderos

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between

Please Login or Register  to view this content.

tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Please Login or Register  to view this content.

Regards, TMS

You can include a code to unprotect the sheet before accessing the worksheet in the code and protect it again after the action is completed like

ws2.unprotect and then ws2.protect

Hope that helps.