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 |
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 |
All times are GMT +1. The time now is 01:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com