Events for a Protected Worksheet

[jpendegraft]

I am trying to launch a simulated Conditional Formatting function (
have more than 3 scenerios) in code. It all works until I protect th
worksheet...I have several cells that I want to disable the user fro
selecting..

Is there a paticular event that can be used to work around this or is?
I want to run the code in the "unlocked" cells while keep the users ou
of other cells....

Cheers

 

[Tom Ogilvy]

In your event code you can unprotect the sheet, make your changes, reprotect
the sheet.

 

[jpendegraft]

Thanks Tom!

A voice of reason in my storm....