Excel Shortcut-key to PasteSpecial

[DSLA]

I have the code to Paste Special (values): Selection.PasteSpecial Paste:=xlValues

But how can I add the command to a Shortcut-key to Excel? (not just a specific sheet, i mean the whole Excel to use in all files i use)

Thanx : )

 

[alansidman]

Create a file called Personal.xls, Save it in the XL Start folder within the Programs folder. You may have to search for it. this is where mine is C:/Program Files/Microsoft Office/Office 10/XLStart. Whenever Excel starts it will launch this file. Keep this file open and save all your macros/ special needs to this file and it will work in all open spreadsheets.

Alan

 

[Ron Coderre]

Actually, it's pretty fast to just type this key sequence:
ALT E S V

But, if you must have a keyboard shortcut,

• Put your macro in your PERSONAL.XLS
• ALT+F8
...Select your macro
...Click the Options button
...Assign this shortcut: CTRL+J

Then, whenever you're in copy/paste mode, CTRL+J will run your macro

Is that something you can work with?

 

[DSLA]

I got the macro working with the help, thank you : )

 

[emjeff99]

Thanks! This is great! I've been looking for a shortcut for paste values for FOREVER! Thanks as always!