View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
reggie reggie is offline
external usenet poster
 
Posts: 30
Default Unlocking and locking a specific cell

Is it possible when an entire sheet is protected if a user was to click on a
specific cell(A65) to temprarily unlock let them edit it and lock it back? if
so, can someone give me and example on how i might be able to do this.

The reason i need to lock it and unlock it is because im using the protect
worksheet fuction..so it locks my whole worksheet but i need some of the
fields to stay unlocked all the time.