Hi there.
I made a template for a protocol meant to be filed daily. The idea is this: you open the workbook, you see only an almost empty sheet with a button. The button launches a VBA-macro that saves a copy of the file (Workbook.SaveAs), unhides a second sheet (with the actual protocol) and deletes the starting sheet.
The problem is, when the copy gets saved, the ORIGINAL file, that is, the template, forgets/deletes the module in which my macro is stored, which is obviously a pain.
Is there a possibility to save the macro within the file (and not in “My Macros and Dialogs”), and having the macro staying there even when I save a copy?