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