Activate cell in protection mode
 

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

Activate cell in protection mode
 

Amnon Wilensky;268198 Wrote:
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
When which sheet is protected, the source or the destination?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=74835

Activate cell in protection mode
 

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


"Amnon Wilensky" wrote in message
...
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

Activate cell in protection mode
 

The Source,
Amnon

"Simon Lloyd" wrote in message
...

Amnon Wilensky;268198 Wrote:
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
When which sheet is protected, the source or the destination?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=74835

Activate cell in protection mode
 

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
**********


Amnon Wilensky;268198 Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=74835

Activate cell in protection mode
 

Thanks,
Problem solved,
Amnon

"Joerg Mochikun" wrote in message
...
Unlock the predefined target cell (Format|Cells|Protection)


"Amnon Wilensky" wrote in message
...
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

Activate cell in protection mode
 

Thanks,
Amnon

"Simon Lloyd" wrote in message
...

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
**********


Amnon Wilensky;268198 Wrote:
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


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile:
http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=74835