How about just adding another icon to your favorite toolbar.

Tools|Customize|commands tab|edit category
scroll down the right hand side and drag "paste values" to that favorite
toolbar.


pugsly8422 wrote:

I have a worksheet with thousands of formulas. I've been having to copy the
results from one worksheet, and use paste special to put only the results on
another page. This is eating up a large amount of my time. I heard someone
mention something about creating a "push button" or shortcut so you can do it
faster. Is this possible? If so, how would I do this?

Thanks in advance for your help!

--

Dave Peterson