Archive of Mr Excel Message Board

Back to Edit in Excel archive index
Back to archive home

"Paste Special" > "Values" Toolbar Button

Posted by James on July 13, 2001 6:44 AM

Is there a way/how would I create a toolbar button in Excel that would automatically when depressed "PASTE-SPECIAL" > "VALUES" without me having to enter any menus? - (Using Excel 97)
Thanks for any assistance

Not a button but...

Posted by Alix on July 13, 2001 6:55 AM

Easiest thing to do is to copy the range you want, select the area/cell to paste into.
Hold down the alt button and press ESV
then press return

Re: "Paste Special" > "Values" Toolbar Button

Posted by Joe Was on July 13, 2001 10:12 AM

Sub sPaste()
'This code pastes the format and value of the current selection,
'to the active range. The Macro option has been set to Hot-key Ctrl-s but can be assigned to the toolbar.

ActiveCell.Select
Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
False, Transpose:=False

End Sub

To asign to a custom toolbar button:
Menu; Tools-Customize Commands-Macros-Categories
Commands-Custom Drag button to toolbar
Right-Click the toolbar button, Assign macro
Macro name "Name"

Hope this helps. JSW

Re: "Paste Special" > "Values" Toolbar Button (Text error above!)

Posted by Joe Was on July 13, 2001 10:16 AM

This code special pastes the selected values to the selected range.

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.