Good afternoon,
I constantly have to paste the results of formulas into
other worksheets as values. Is there anyway I could
create a button that would paste values would work like
the format paintbrush? Thanks for your advice!
Brian

Do you mean like the Paste Values button?? :-)

Check out the buttons in View / Toolbars / Customise / Commands Tab / Edit Menu
/ Paste Values Button - Drag it to a toolbar

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------



"Brian" wrote in message
...
Good afternoon,
I constantly have to paste the results of formulas into
other worksheets as values. Is there anyway I could
create a button that would paste values would work like
the format paintbrush? Thanks for your advice!
Brian


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.560 / Virus Database: 352 - Release Date: 08/01/2004