Relinking Buttons and code on copied worksheets?

[teachman]

Hello,

I am in a project that utilizes Excel to build data entry forms that are printed out and filled out with a digital pen in the field. The pen is then docked back to the computer and the data is downloaded to the Excel file that printed the form.

The result of this is that the form itself, is Sheet1 in the workbook and the process makes a copy of Sheet1 inserts it as the last worksheet, Sheet6 for example, and fills in the data collected. The problem is that Sheet1 has an Error Checking button/vba script imbedded in it. When the worksheet is copied, the button and macro code are also copied but the macro is run against Sheet1 and not Sheet6. Even though, Sheet6 has the macro code with it.

What I would like to do, programmatically, is to link the Error Check button on Sheet6 with the macro code that is also with Sheet6.

Any ideas?

Thanks,

George Teachman

 

[HalfAce]

Kind of hard to tell without seeing the code, but my idea is...
Is the code specifying sheet1 by name? If so, then I would think anywhere it references Sheet1, you might simply change that to read "ActiveSheet", assuming that (per your example) Sheet6 is the active sheet when you want to run the code from sheet6.

(Does that make sense?)