| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Replace normal paste with Paste As Text
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. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find and replace help with copy paste | Excel Discussion (Misc queries) | |||
| How do I paste to append instead of replace existing data? | Excel Discussion (Misc queries) | |||
| Paste in Find and Replace Dialogue | Excel Programming | |||
| Paste in Find and Replace Dialogue | Excel Programming | |||
Threaded Mode
