Disabled "Save" and "SaveAs"

D

Diana

Hi :

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

Cheers,
D.
 
A

Alan

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.
 
Top