I need istance with Excel 07?

I need to make a copy of a worksheet in Excel that includes a Command on including VBA coding. Whenever I copy the sheet, either the on doesn't copy over, or when it does, I have to reenter the coding. Then, when I try to execute the on I get runtime errors. Can anyone provide some insight as to how to successfully copy the sheet including an executable on?