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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Disable Cut/Copy/Paste in Excel 2010 0
Cut & Paste in Excel without erasing cell borders? 1
Copy and paste ONLY conditional format 1
Paste Problem 1
Make Border Lines Stay during Cut & Paste of Cell Contents 3
Special Copy, Paste Special macro 3
Paste special function in macros fail if we disable application cellDrap Drop 2
Copy and Paste Loop 2

Back
Top