Anforya, it is not disabling the buttons but the code below should prevent a save. Place the code in the ThisWorkbook module
To allow you to save, in the code window press CTRL + G to open the Immediate Window, type![]()
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean) If SaveAsUI then Cancel = True End Sub
Application.EnableEvents=False
and press Enter.
To re-enable events
Application.EnableEvents=True
Obviously this won't work if they don't enable the macros.
Bookmarks