Remove option to save

[Guest]

How do I make a shared excel file, when opened, to not include the option to
save, save as, save as webpage, etc….. And I would also like to remove the
little save icon on the toolbar. All this while not affecting the users
program when not accessing the specific file.

 

[Guest]

Put code in the 'This Workbook' 'BeforeSave' procedure that closes the
workbook instead of saving it. Something like...

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
MsgBox "Not this time"
ThisWorkbook.Saved = True
ThisWorkbook.Close
End Sub

HTH,
Gary Brown