Retaining the Macro code for disabling Save option in Excel

[nikit]

Hi,
I can disable the save option using below code in ThisWorkbook.
After I close the current excel sheet, the Macro code disappears when I open new excel sheet.
I tried applying breakpoint, but this is not user friendly.
Please get back soon for above query.

Option Explicit

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
    Cancel = True
End Sub