LondonChick,
Where do you have the two subroutines?
The CommandButton1_Click should be in the worksheet module and the
mcrCostAccounting should be in a standard module.

Also make sure the button you created is CommandButton1.
The easiest way to do this is to go into design mode and double click
on the button. It will take you to the VBA editor show you the code
behind that button.

HTH


--
bhofsetz
------------------------------------------------------------------------
bhofsetz's Profile: http://www.excelforum.com/member.php...o&userid=18807
View this thread: http://www.excelforum.com/showthread...hreadid=381235