I want to add Paste Values to the right click menu in Excel 2007. Can this be done without recording a separate macro to run it? What I mean is If I add the command itself to the right click menu, can it run of of the standard RightClick -> Paste Special -> Values option, or must I record a macro that does those steps each time?
Last edited by Tirren; 12-30-2008 at 01:55 PM.
Creating a macro and assigning a permanent keyboard shortcut is much less complicated than what you're asking. And in the end activating a keyboard shortcut is the same number of steps as right-click-choose...so, macro gets my vote.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
Well you can add Paste Values (no macro required) directly to the QAT, in fact you can do any of the paste special functions via the QAT no macro required. I assumed it might be just as easy to add them to the Right Click menu, I just have no clue how to do it. Seems pointless to write another macro, to perform the exact same task.
Hello Tirren,
I don't have 2007, but it seems reasonable. I have modified the cell context menu many times in Excel 2003 to provide users with faster data entry.
Sincerely,
Leith Ross
In 2003, what method did you do for adding an excel pre-programmed feature to the menu. The only method I know currently is recording a separate macro to accomplish the same feat, then adding that macro to the right click menu. Problem is, you can't undo actions done by a macro, so if I make a mistake I cannot easily fix it.Originally Posted by Leith Ross
If I use the paste special function already designed in Excel, then I should be good. I just don't know how to contextually add it to the right click menu. Here is the code that I have to add a pre-programmed macro to the right click... perhaps you can tell me what to edit, to point to the excel function already available:
Please Login or Register to view this content.
Hi Tirren
Try:
Please Login or Register to view this content.
AWESOME! You got it! You also answered a question I had in another post, not sure if you had intended to.
Might I ask where you find those ID's?
I'm glad it helped.
I don't have a full list of the ids for excel 2007. You find here a list of the ids for excel 2000. I'm not sure they all work in xl2007 and it doesn't have the paste values. If you find a more recent list please post it.
http://support.microsoft.com/kb/213552/en-us
Thank you very much Tirren !! You saved me !!!
Last edited by fablepd; 10-01-2012 at 08:11 AM.
lecxe i cannot find ID 370 in the support.microsoft.com you gave us ;(
i'm looking for the "paste as Unicode text" ID. Can you help me please ?
Thank you very much.
Fabio
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks