Excel Save option only through macro

Hi All,

Im currently working on an excel file. i want to disable the save / Save As option in the file menu or buttons and allow saving only through a macro. Also the file should be saved only with a different name as i do not want my original file to be messed.

I tried to below code to disable saveand it worked. But when i open the original file the below code s disappeared . !!!!

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
 
If SaveAsUI = False Then
Cancel = True
MsgBox "You cannot save this workbook. Use Save As"
End If

End Sub

Can anyone please help me out !! ...
Thanks in Advance