Heya, me again.
I have a worksheet set up so when the user opens it, it acts as a template. Userforms guide the user through filling it out, then invites the user to save the sheet with a new name.
How can I save the sheet and strip it of all the macros? The worksheet will be opened again (and again, and again, and...) later on, but I don't want the event-triggered macros to run more than once on the form... I'd rather they not be there at all.
Can I save the workbook, with a new name, sans macros and forms?
Thanks yet again for your help!
I have a worksheet set up so when the user opens it, it acts as a template. Userforms guide the user through filling it out, then invites the user to save the sheet with a new name.
How can I save the sheet and strip it of all the macros? The worksheet will be opened again (and again, and again, and...) later on, but I don't want the event-triggered macros to run more than once on the form... I'd rather they not be there at all.
Can I save the workbook, with a new name, sans macros and forms?
Thanks yet again for your help!