The OP is dealing with a template workbook (*.xlt), that is why I have suggested opening a new workbook from the template. By not enabling macros the auto open will not run & the workbook can be edited without it deleting the macro.