Disable save/save as in Excel 2010

[jhamerarthrex]

I need to prevent users from saving a workbook except when a macro calls for a save. THis is driving me crazy...there has to be a way. I have a private sub for a workbook open event to require a user to login before the file will open and using any other workbook events does not work

[zmbd]

I'll let you fill in the blanks:

However goto the VBA-editor
Right click on "This Workbook" and view code

Option Explicit
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)

End Sub

tada
:)