Disabling Save As

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Is there a feature of Excel or a macro that I could write
to disable the save as?
 
Hi Andrew

Try this events in the ThisWorkbook module
It will disable it when you activate the workbook and restore it when
you close it or select a other workbook

Private Sub Workbook_Activate()
Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=748, Recursive:=True).Enabled = False
End Sub

Private Sub Workbook_Deactivate()
Application.CommandBars("Worksheet Menu Bar").FindControl _
(ID:=748, Recursive:=True).Enabled = True
End Sub
 
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

Disable Macro Alert 2
Disabling Save Button 1
Excel 2007: Saving a file with a Macro 1
PowerPoint High Resolution Images from PowerPoint 0
Excel 2003 save as .XLSX 10
Macro-enabled workbooks 1
Disable spreadsheet when copied to incorrect file path or differen ip address 4
Does Disabling Macros affect Hyperlinks 1

Back
Top