Apologies for repost (kind of) - Disable Cut function but allow Paste

[mikeymay]

Please see previous thread .....

http://www.mrexcel.com/forum/excel-questions/694926-disable-cut-function.html#post3436093

I am in desperate need of a solution that will allow a user to Copy & Paste but disable the DragandDrop/Cut functions within the workbook.

The one caveat to this is that the user MUST be able to copy data OUT of the workbook.

Using

Application.CellDragAndDrop = True

when the workbook is deactivated clears the clipboard meaning the user cannot paste to another workbook.

If anyone can help with this I will send you chocolate cake.......


Thanks

 

[Dryver14]

Look at this older thread

Excel Disable "Cut" command

 

[mikeymay]

Sorry, but I forgot to mention that the users will be using 97-2003 and/or 2007.

I know the OnKey commands don't work in 2007 so I need a solution for both platforms.

Thanks for looking into this though.