Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I was reading in this other post how to set up VBA code to paste values in Excel. I understand how to create the VBA code.

I would like to set the keyboard shortcut to Ctrl d but Excel pops up an error and says this is taken when I try to utilize that.

The other post alludes to the idea that you can overwrite these or create/edit VAB code that will let you use Ctrl d without Excel knowing it is different.

I am using Excel 2010 on a PC.

share|improve this question
Can you upload a screenshot of the error? I just checked with Excel 2010 and was able to assign Ctrl+D as a shortcut to my macro just fine. What does pressing Ctrl+D do for you? Perhaps you've already assigned it to another macro? – Karan Apr 30 '13 at 18:41

If you are unable to get a macro assigned, an alternative is to either a) assign a button to your ribbon (I use that all the time), or, b) if it has to be a keyboard solution (I, too, like keyboard shortcuts), SuperUser Doug Glancy answers this with the shortcut that already exists in Excel (along with other great info) in his post:

"2.Ones like Alt-E-S-V for Edit > Paste Special > Values " (and then press Enter)

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .