Activate cell in protection mode

[Amnon Wilensky]

Hi,
I have a code that by clicking on any cell on the spreadsheet passes the
information to predefined cell.
The problem is that when I protect the spreadsheet, the code doesn't work.
Any solution?
Thanks,
Amnon

 

[Joerg Mochikun]

Unlock the predefined target cell (Format|Cells|Protection)

 

[Amnon Wilensky]

The Source,
Amnon

When which sheet is protected, the source or the destination?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)

 

[Amnon Wilensky]

Thanks,
Problem solved,
Amnon

Unlock the predefined target cell (Format|Cells|Protection)

 

[Amnon Wilensky]

Thanks,
Amnon

Then if your sheet is just a point and click you could use this in the
worksheet code module:
**********
Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
Me.Unprotect Password:="mypassword"
'YOUR CODE TO MOVE DATA TO CELL
Me.Protect Password:="mypassword"
End Sub
**********




--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)