How do I disable save/save as and control +s and f12 in excel 2007?
I want o disable those and only allow save feature through the macro I established
Software/Hardware used:
excel 2007
Software/Hardware used:
excel 2007
ASKED:
September 27, 2010 7:10 PM
UPDATED:
October 1, 2010 10:44 AM
RELATED QUESTIONS
- Create a macro in Excel 2007 to disable save
- Excel 2007 saves the file when I close it without prompting me even though no changes were done
- How can I retrieve an Excel file saved in Hotmail?
- How do I save as XLAM Excel add-in
- Why are my Word and Excel documents automatically zipping in Microsoft 2007?
Answer Wiki:
For Excel 2003,
After you press ALT+F11, put the following VBA code in "Workbook" object
Private Sub Workbook_Open()
disablesaveas
End Sub
Then Add "Module" and paste this in
Sub disblesaveas()
CommandBars("File").Controls("Save As...").Enabled = False
End Sub
Then close the file and open it again
For Excel 2007 users,
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
If SaveAsUI Then Cancel = True
End Sub
Just do for the rest.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
