Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste function without affect locked cells
Dear all
i am working in excel xp edition i have three spreadsheets, which are locked. Only the sheets, not the workbook. Imagine that in the sheets are locked the lines 100, 200 210 and 250, only, which are containing sum formulas Also those lines are locked from A to T. So when the end user who fills the data try to copy data from column Z which is unlocked to column M for example he is not allowed to do it because some of the cells are locked. There is any possibilty, by using visual basic to make a function where when the user makes the copy and then procceed to the paste function the cells that are not locked to get the values from the paste and the protected cells not to be affected? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Paste function without affect locked cells
There is any possibilty, by using visual basic to make a function...
Yes, but you would have to make your own substitute Copy and substitute Paste function in VB. And use Onkey to replace Ctrl-c and Ctrl-v, and replace the Edit menu functions. Quite a hassle... -- Jim "Manos" wrote in message ... | Dear all | | i am working in excel xp edition | i have three spreadsheets, which are locked. Only the sheets, not the | workbook. | Imagine that in the sheets are locked the lines 100, 200 210 and 250, only, | which are containing sum formulas | | Also those lines are locked from A to T. | So when the end user who fills the data try to copy data from column Z which | is unlocked to column M for example he is not allowed to do it because some | of the cells are locked. | | There is any possibilty, by using visual basic to make a function where when | the user makes the copy and then procceed to the paste function the cells | that are not locked to get the values from the paste and the protected | cells not to be affected? | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
Locked Cells and Copy/Paste | Excel Worksheet Functions | |||
paste locked cells and unlocked cells in protected sheet | Excel Worksheet Functions | |||
Can you paste to protected spreadsheet and skip over locked cells? | Excel Discussion (Misc queries) | |||
conditional formats affect other cells | Excel Discussion (Misc queries) |