LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 57
Default add "paste values" to right click menu

From the msword forum I see a reference to
http://www.word.mvps.org/FAQs/Custom...oToToolbar.htm,
which shows a way to add an item to the right click menu or what seems to be
more properly called shortcut menu.

I am trying to do the same thing in excel but in Tools-Customize-Toolbars
there is not such thing as "shortcut menu" used by the above referenced
technique, or at least I have not found it. However, from
Tools-Customize-Commands (then choose "Edit" on the left hand pane), I was
able to find the actual "paste values" menu item and have successfully
dragged & dropped it to my File-Edit menu.

I did see the post in this forum on "PAStE SPECIAL" [sic] by Dave Peterson
on 2007/02/24 on how to assign a macro to a keystroke shortcut. However
actually adding that option menu item to the right click menu is preferred
since it: a) is a personal preference, and b) much more importantly, avoids
the inability to undo issue noted by another user in the "PAStE SPECIAL"
thread.

So my two questions:

1) How do you add the "paste values" menu item onto the right click menu (or
the shortcut menu, although that term might not be used within the excel
context)?

2) How do you add the "paste values" menu item onto ALL THE right click
menus since it appears that the right click menu changes depending on context.

Thanks a lot.



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can I have "Shift-Click" or "Ctrl-Click" Code on Form List? MikeZz Excel Programming 0 June 13th 07 12:58 AM
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F daves Excel Discussion (Misc queries) 3 April 24th 07 04:52 AM
It's not CommandBars("Cell"), right-click menu! Tetsuya Oguma Excel Programming 1 July 4th 05 07:02 AM
What does the "Paste Special Dropdown" popup menu do? R Avery Excel Programming 2 December 15th 04 02:28 PM
disable right mouse click on "Worksheet Menu Bar" Max Potters Excel Programming 2 November 6th 04 02:45 PM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"