Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 118
Default 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

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5,302
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 118
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Validation Data using Validation Table cell range..... Dermot Excel Discussion (Misc queries) 16 January 5th 10 09:35 PM
How do I get data validation to disallow specific entries a-one-and-a-two Excel Worksheet Functions 10 January 5th 07 10:52 PM
Disallow cell entries hopeace Excel Discussion (Misc queries) 3 October 14th 05 12:19 AM
Disallow Paste Steph[_3_] Excel Programming 3 June 22nd 05 05:37 PM
Disallow Copy/Paste Worksheet GT Excel Programming 1 September 16th 03 03:23 PM


All times are GMT +1. The time now is 09:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"