Disabled "Save" and "SaveAs"

  • Thread starter Thread starter Diana
  • Start date Start date
D

Diana

Hi :

How can I do disabled the options "Save" and "Saveas" for
one especific worksheet ?

Cheers,
D.
 
In the ThisWorkbook module,

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

Put this into a normal module and run it to save the file
Sub Save()
Application.EnableEvents = False
ActiveWorkbook.save
Application.EnableEvents = True
End Sub

Regards,
Alan.
 
Back
Top