Can Paste-Special-Values be VBA programmed?

  • Thread starter Thread starter Simon Hughes
  • Start date Start date
S

Simon Hughes

Paste-Special-Values is a sequence that I seem to use quite a lot and I'd
like to make it a shortcut choice when right-clicking on a cell. So far
though, I can't seem to find any way to do it. (I know how to put something
into a shortcut menu, just not how to recreate the Paste-Special-Value
part.) Any suggestions?
 
You may simulate the paste special option with the sendkey commands in VBA

Avi
 
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

Paste Special Values 3
Change paste to paste special 3
How Do Configure Paste Special Selections 1
Getting Data Validation to execute when using Paste Special... Val 3
VBA code to replace Past Special 4
Paste Special, Values only 6
Preventing pasting except for Paste Values 8
Change paste to only paste values 1

Back
Top