Paste Special hot key creation

[gomezla]

In the new 2007 version , can a specific hot key be created to perform Past Special Values? This key assignment was available in 2003, but we can't find it in the new 2007.

 

[GlennUK]

What key assignment in 2003 exactly?

 

[gomezla]

In 2003, while customizing the toolbar in the dialog box to add a command icon (paste special), if you right mouse click you can assign a "name" which can include "Alt P" or any combination with the Alt key you want.

 

[GlennUK]

I thought I knew all the tricks ( well, 99.9% of them ) but that's not one I've heard of before. Am just trying it now, and can't get it to work. Do you actually type Alt P in the name?

 

[gomezla]

The default is Alt P and we just accept it. It puts an apersand in front of "Paste Special".

 

[GlennUK]

I thought you said the hotkey was for Paste Special Values at the beginning of this thread?

 

[gomezla]

Yes, it is about Paste Special. Cntrl P is for the print.

 

[GlennUK]

There is a difference between the buttons for Paste Special and Paste Special Values, and I was asked which button the Alt P is the hotkey for?

 

[gomezla]

Sorry, it's for the Paste Special Values.

 

[GlennUK]

Sorry, it's for the Paste Special Values.

OK got it now.

Unfortunately I've run out of time. I am now at home, about to go on holiday for 2 weeks. I hope someone else out there with 2007 can help you.