Shortcut key

[Steph]

Is there a way to assign a shortcut key stroke (like Ctl Z) to Paste
Special/Values?

[Ron de Bruin]

Hi Steph

You can make your own macro and assign a shortcut key or add the button
to your toolbar manual or with code.

View>toolbars...Customize on the edit list a icon with 12 in it
Drag it to your toolbar

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Steph" <[email protected]> wrote in message news:%[email protected]...
> Is there a way to assign a shortcut key stroke (like Ctl Z) to Paste Special/Values?
>

[David McRitchie]

Example of a macro to use
http://www.mvps.org/dmcritchie/excel/paste.htm#values

The actual code is one line, the rest is for error checking

Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
SkipBlanks:=False, Transpose:=False


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Ron de Bruin" <[email protected]> wrote in message news:[email protected]...
> Hi Steph
>
> You can make your own macro and assign a shortcut key or add the button
> to your toolbar manual or with code.
>
> View>toolbars...Customize on the edit list a icon with 12 in it
> Drag it to your toolbar
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
> "Steph" <[email protected]> wrote in message news:%[email protected]...
> > Is there a way to assign a shortcut key stroke (like Ctl Z) to Paste Special/Values?
> >
>
>

[Ron de Bruin]

And if you want it in the cell contex menu run this one time

This example will add the Paste Special values button to the Cell menu after the Paste option.


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




--
Regards Ron de Bruin
http://www.rondebruin.nl


"David McRitchie" <[email protected]> wrote in message news:[email protected]...
> Example of a macro to use
> http://www.mvps.org/dmcritchie/excel/paste.htm#values
>
> The actual code is one line, the rest is for error checking
>
> Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, _
> SkipBlanks:=False, Transpose:=False
>
>
> ---
> HTH,
> David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
> My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "Ron de Bruin" <[email protected]> wrote in message news:[email protected]...
>> Hi Steph
>>
>> You can make your own macro and assign a shortcut key or add the button
>> to your toolbar manual or with code.
>>
>> View>toolbars...Customize on the edit list a icon with 12 in it
>> Drag it to your toolbar
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>> "Steph" <[email protected]> wrote in message news:%[email protected]...
>> > Is there a way to assign a shortcut key stroke (like Ctl Z) to Paste Special/Values?
>> >
>>
>>
>
>

[Jeff Standen]

Alt E S V Enter works for me

Jeff

"Steph" <[email protected]> wrote in message
news:%[email protected]...
> Is there a way to assign a shortcut key stroke (like Ctl Z) to Paste
> Special/Values?
>

[David McRitchie]

Hi Steph,
You can create an equivalent macro and assign it a shortcut key.
http://www.mvps.org/dmcritchie/excel/paste.htm#values
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Jeff Standen" <[email protected]> wrote in message news:[email protected]...
> Alt E S V Enter works for me
>
> Jeff
>
> "Steph" <[email protected]> wrote in message
> news:%[email protected]...
> > Is there a way to assign a shortcut key stroke (like Ctl Z) to Paste
> > Special/Values?
> >
>
>