Forum Discussion
Solved
Opening a copy of an excel workbook and retaining original unchanged
I have a 'master' workbook which I want to make available to users but I want to be able to open a copy of the workbook and retain the master copy unchanged. Is there a Vba code to enable this? I have tried a few things using the 'before open' event but am unable to find the correct code.
Save the workbook as an Excel Template (*.xltx), or if it contains VBA code, as an Excel Macro-Enabled Template (*.xltm).
The default action for a template is to create a new workbook from the template.
2 Replies
Save the workbook as an Excel Template (*.xltx), or if it contains VBA code, as an Excel Macro-Enabled Template (*.xltm).
The default action for a template is to create a new workbook from the template.
- Hi Hans
Excellent thank you
