L
lcmbeatrice
I am using Excel 2000 and I have created a template for reporting with
protected cells.
Cells which I allows for data input are unprotected.
Problem is, the cells protection does not protect for changes in cell
format (I have coloured all unprotected cells with yellow background).
When someone do a copy and paste, the format of the unprotected cells
will be changed.
The only way I can think of is to intercept "CTRL-V" or the normal
paste function and change it to "Paste as Text".
How can I do this?
Please help.
protected cells.
Cells which I allows for data input are unprotected.
Problem is, the cells protection does not protect for changes in cell
format (I have coloured all unprotected cells with yellow background).
When someone do a copy and paste, the format of the unprotected cells
will be changed.
The only way I can think of is to intercept "CTRL-V" or the normal
paste function and change it to "Paste as Text".
How can I do this?
Please help.