What is your intention for creating the button? If it is simply to run
Paste Special with the Values Only option, then perhaps you could
explore the option of using keyboard shortcuts instead.

Ctrl+C allows you to copy a range of cells. The shortcut Alt+E followed
by Alt+S opens the paste special dialog box. With the dialog box open,
hit Alt+V followed by Enter to paste values only.

Hope this helps.


--
C01d
------------------------------------------------------------------------
C01d's Profile: http://www.excelforum.com/member.php...o&userid=34422
View this thread: http://www.excelforum.com/showthread...hreadid=549467