Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i activate in reduced functionality mode | Excel Discussion (Misc queries) | |||
Copy worksheet in protection mode | Excel Discussion (Misc queries) | |||
Cell Protection vs. Worksheet Protection | Excel Discussion (Misc queries) | |||
Activate my Excel 2003 but it still runs in reduce mode | Excel Discussion (Misc queries) | |||
Activate Cell | Excel Discussion (Misc queries) |