Copy and Paste Cells

  • Thread starter Thread starter Lee
  • Start date Start date
L

Lee

I have an application that I have turned off the Cut,
Paste Special, and Drag/Drop.

Is there a way to reassign the default paste control (22)
to perform a paste of everything but borders?

Or can the paste special function (755) be locked so that
it doesn't give the user a choice and automatically
defaults to the paste all but borders option. (from the
toolbars and the pop-ups)

I appreciate any help. Thanks,

Lee
 
Lee,

According to Excel help you can use the PasteSpecial method with the
parameters that you select for example paste:=xlPasteAllExceptBorders. I
just had a little play with it, but couldn't get it to work.

Steve
 
Back
Top