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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Allowing user to choose to accept saveas option 4
Macro NOT completing 4
Extracting xlsx data from structured Storage 0
Using SaveAs 3
Disabling SaveAs and Save? 7
The specified dimension is not valid for the current chart type 0
SaveAs wk3 file type error message 1
SaveAs method error 3

Back
Top