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.

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


"Micropro76" wrote:

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.