View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
jpendegraft[_18_] jpendegraft[_18_] is offline
external usenet poster
 
Posts: 1
Default Events for a Protected Worksheet

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

--
Message posted from http://www.ExcelForum.com