Icon to paste Formulas only

[stef]

Excel 2002 SP3
Win XP Pro SP2

Hi,
There are icons for Paste Values, and Paste Formatting, both of which
very useful but I cannot find an icon to add to my toolbar to simply
"Paste Formulas" (in the Paste Special).
Is there one somewhere that I am missing?

 

[Bernie Deitrick]

stef,

There is no default paste formula button.

You need to add a custom button to an existing commandbar - right click a CB, choose Customize, then
under the Categories choose Macros, then drag the smiley face from the commands section to where you
want your button. Right click the smiley face, and assing the macro below to it (First store the
macro in your Personal.xls so that it will be available whenever you have Excel open). You can edit
the smiley face to some other more appropriate icon....

HTH,
Bernie
MS Excel MVP

Sub PasteFormula()
Selection.PasteSpecial Paste:=xlFormulas
End Sub

 

[stef]

Thanks a lot Bernie. Very helpful.

stef,

There is no default paste formula button.

You need to add a custom button to an existing commandbar - right click a CB, choose Customize, then
under the Categories choose Macros, then drag the smiley face from the commands section to where you
want your button. Right click the smiley face, and assing the macro below to it (First store the
macro in your Personal.xls so that it will be available whenever you have Excel open). You can edit
the smiley face to some other more appropriate icon....

HTH,
Bernie
MS Excel MVP

Sub PasteFormula()
Selection.PasteSpecial Paste:=xlFormulas
End Sub