Home ยป Workbook.BeforeSave event
Learn
Excel Macro: Limit The Number of Times a Workbook Can Be Used
Suppose you want to send a demo file for users to check, but you don't want it to be used more than […]
Workbook.FullName property Kill statement Workbook.ChangeFileAccess method DocumentProperties.Add method Choose function MsoDocProperties enumeration Workbook.CustomDocumentProperties property Workbook.BeforeSave event Workbook.RemovePersonalInformation property Workbook.Close method Workbook.Saved property Workbook.Open event Workbook.Save method With statement If...Then...Else statement On Error statement
Learn
Remove Document Inspector Warning Include Personal Information
You may get warning message about the Document Inspector when you want to save Excel file. Be careful! Parts of your document […]
Docs
Workbook.BeforeSave event
Occurs before the workbook is saved. Syntax expression.BeforeSave (SaveAsUI, Cancel) expression A variable that represents a Workbook object. Parameters Name Required/Optional Data […]