tools=customize

go to the middle tab,

Select edit in the left window

in the right window you will find a PasteSpecial button, drag it to a
toolbar.

--
Regards,
Tom Ogilvy

Rick wrote in message
...
I am trying to create a command button that will copy a
cells values only. Expamle:
Copy,PasteSpecial,Values: B10 to B5.
B10 has a =Sum in it and all I want to copy is the amount
in B10 to B5 and I need a button to do this.
Can anyone Help me.

Thanks
Rick