Paste function without affect locked cells

[Manos]

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?

 

[Jim Rech]

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