A way to force paste special values

[pdauction]

Hi,

I have a workbook that will be open to multi users. I have a lot of data validation and formatting etc that I want to retain. I have therefore added the following coding so the user can't delete any data validation and formatting.

http://www.vbaexpress.com/kb/getarticle.php?kb_id=373

I will also add in code to this so they can't fill down and fill right at some point!

The problem is, is that the users will sometimes probably want to paste quite a sizeable amount of data (from another source) into it rather than type each entry one at a time.

The best way i could think to do this would be to add a button with the following code, which forces pastevalues.

Please Login or Register  to view this content.

The trouble is, is that as soon as I Activate my workbook to paste entries from another source it knocks of the cutcopymode off and so it doesn't work.

I presume somewhere in the code in the link I provided the CutCopyMode goes to false.

Can anyone please help or think of an alternative?

Many Thanks
Paul

[Steffen Thomsen]

Then try detecting it

Please Login or Register  to view this content.

[pdauction]

Hi,

Thanks for the help.

Unfortunately this still does not seem to work. I have now attached the relevant sheet. Not sure why the copy turns off nor why it ignores the application.cutcopymode request.

Hope you can help further.

Paul

[pdauction]

I have now sorted this buy changing the following...

Please Login or Register  to view this content.

To this

Please Login or Register  to view this content.

Simply put when CellDragandDrop was disabled this 'knocked' off what had been copied. I have therefore also had to add code elsewhere in my vba (worksheet change) to turn CellDragandDrop back off.

Cheers
Paul