Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable paste option in worksheet.
Hi,
I have a column where I have applied validation for dates but when someone uses the paste option then the validation is of no use. I want a macro which will not allow the user to paste anything in a particular column. The user has to enter the date without using the copy paste option. Basically i want to disable the paste option in a particular range. Regards Heera |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Disable paste option in worksheet.
One way:
Unlock (Format/Cells/Protection) any cells that you want the user to be able to type or paste into, then choose Tools/Protection/Protect Worksheet. A macro won't prevent a paste since no event will be fired until after the paste is accomplished. You *could* use an event macro (Worksheet_Change) to reapply validation if it was removed by a paste, but you'll then have to deal with deciding which value to insert (or use another event to store the value). In article , Heera wrote: Hi, I have a column where I have applied validation for dates but when someone uses the paste option then the validation is of no use. I want a macro which will not allow the user to paste anything in a particular column. The user has to enter the date without using the copy paste option. Basically i want to disable the paste option in a particular range. Regards Heera |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Disable print option of a worksheet/workbook | Excel Discussion (Misc queries) | |||
Disable copy paste option on a particular cell | Excel Worksheet Functions | |||
how can i enable or disable the paste option in excel 2000 | Excel Worksheet Functions | |||
How do I disable cut and paste in protected unlocked worksheet | Excel Worksheet Functions | |||
Code to disable "paste" as an option | Excel Programming |