Copy code progammatically (Excel 2000)

Topic

New Reply

When the user clicks the Post button on the InputSheet of his template, data is captured on a Summary sheet and the InputSheet is moved to a new file and saved. (A hidden copy of the InputSheet is copied and renamed to replace the one moved out)
A change event pops up a calendar when the user selects certain cells on the InputSheet as long as it’s part of the template.
But the form is not copied. How can I have the Calendar form copied to the new file so the change event will still work?

Reply | Quote

Replies

Copy the entire workbook and remove the sheets you don’t need from the copy. Check out the SaveCopyAs method.

Reply | Quote

Thanks. Seems so obvious when you say it!

Reply | Quote