Excel VBA脚本保存然后禁用*更新*

I have created an excel spreadsheet to use as a template for documentation. I have locked the workbook from being changed, with the exception of the cells that need info entered. I then added a vba script that counts up every time the file is opened, with the password protection being unlocked then the vba script updates and password protection is enabled again. This is for my company's own internal document tracking. The problem I am running into is having the file auto save right after the vba script being executed and then have another vba script disable the save feature only allowing the save as feature. I don't want the file to be accidentally overwritten.I have created an excel spreadsheet to use as a