Copy and Paste Cells
 

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

Copy and Paste Cells
 

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
"Lee" wrote in message
...
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