PC Review


Reply
Thread Tools Rate Thread

Add "paste values" to right-click shortcut menu-how do? Excel 2010

 
 
Chet
Guest
Posts: n/a
 
      25th Jun 2010
I had a post about a year ago on how to do this but I am trying to
find out how to do it with Excel 2010 since this code below was said
to work up to version 2003. So does anyone know how to do it for
Excel 2010?

Original post-----
Anyone know how to add "paste values" to the shortcut menu that comes
up when you right-click over a worksheet? John Walkenbach refers to
it in his book Power Programming Techniques 5 but I am missing some
details on how to do this. Thanks, Chet


Response post---------
Bernie Deitrick
--------------------------------------
(1 user) More options Sep 18 2009, 8:15 am
Chet,
For all but XL 2007, code from Ron deBruin:
Sub Add_Paste_Special_Button()
' This will add the Paste Special Values button to the cell menu
' after the Paste option
Dim Num As Long
Num = Application.CommandBars("Cell"). _
FindControl(ID:=755).Index
Application.CommandBars("cell").Controls. _
Add Type:=msoControlButton, ID:=370, before:=Num
End Sub
Sub Delete_Paste_Special_Button()
On Error Resume Next
Application.CommandBars("cell").FindControl(ID:=370).Delete
On Error GoTo 0
End Sub
HTH,
Bernie
MS Excel MVP
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Add "paste values" to right-click shortcut menu-how do? Chet Microsoft Excel Programming 4 18th Sep 2009 05:24 PM
add "paste values" to right click menu =?Utf-8?B?cm9ja2hhbW1lcg==?= Microsoft Excel Programming 6 12th Dec 2007 09:39 PM
How to create a right-click "add then paste" menu item instead of just paste Zen Tobi Microsoft Access VBA Modules 1 19th Apr 2005 04:29 AM
Keyboard shortcut for "copy paste special values?" =?Utf-8?B?U3RhciBBSg==?= Microsoft Excel Misc 2 17th Mar 2005 04:03 PM
Make Excel's "grab and drag" behave like cut and paste "values only" ? tur13o Microsoft Excel Misc 5 14th Nov 2003 01:07 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 12:58 AM.