ExcelBanter - Disallow paste in range of cell containing validation

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Disallow paste in range of cell containing validation (https://www.excelbanter.com/excel-programming/345714-disallow-paste-range-cell-containing-validation.html)

al007

Disallow paste in range of cell containing validation

Is there any macro which will not allow users to paste in a range of
cells containing validation (data has to be input & not pasted)??
Thxs

Norman Jones

Disallow paste in range of cell containing validation

Hi Al007,

See John Walkenbach suggestions at:

http://www.j-walk.com/ss/excel/tips/tip98.htm

---
Regards,
Norman

"al007" wrote in message
oups.com...
Is there any macro which will not allow users to paste in a range of
cells containing validation (data has to be input & not pasted)??
Thxs

al007

Disallow paste in range of cell containing validation

thxs
Norman Jones wrote:
Hi Al007,

See John Walkenbach suggestions at:

http://www.j-walk.com/ss/excel/tips/tip98.htm

---
Regards,
Norman

"al007" wrote in message
oups.com...
Is there any macro which will not allow users to paste in a range of
cells containing validation (data has to be input & not pasted)??
Thxs

All times are GMT +1. The time now is 05:07 AM.