Thread: Cell Protection
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Teresa Teresa is offline
external usenet poster
 
Posts: 169
Default Cell Protection

I have a range of cells D1:G16 with formulae in them, I want to ensure that
the user cant select these cells, how can I do this without any sort of
Password Protection.
I guess its a Private Sub Worksheet_Open()
If Target.Range = (D1:G16)...
.....
....
....

Thanks