Macro
Post the code.
"zephyr" wrote:
I have a workbook with two worksheets.
Worksheet 01 is the summary
Worksheet 02 is the form template.
I have a form button on Worksheet 02, I have tried to record a macro for the
button that does the following
a) copies the worksheet 02
b) re-names the worksheet as 03
c) places the worksheet after 02
d) removes the command button from the new worksheet 03.
e) When the contents of cell A1 & A2 are typed in on worksheet 03, the
contents also appear in the cells B1 and B2 on the summary Worksheet 01.
I want to use the workbook for multiple worksheets with the summary for each
one appearing on the summary Worksheet 01.
When I remove the command button from worksheet 03 a debug error message
comes up.
Your help is appreciated.
|