I want a macro to activate as a workbook is opened either as the original .xltm or as the .xlsm (when template activated).
The macro is the untick a checkbox on the sheet that opens.
Alternatively I want to be able to password protect the template but allow users to create a workbook from the template.
The reason for this question is that I have a template which I want users to actively "tick" the checkbox but some staff have opened the template, ticked the box and saved the template instead of opening and creating a new workbook from the template.
Thanks
The macro is the untick a checkbox on the sheet that opens.
Alternatively I want to be able to password protect the template but allow users to create a workbook from the template.
The reason for this question is that I have a template which I want users to actively "tick" the checkbox but some staff have opened the template, ticked the box and saved the template instead of opening and creating a new workbook from the template.
Thanks