Home ยป Workbook.Open 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
Excel Macro: Refresh All Data Connections on Workbook Open
This Excel macro code allows you to refresh all data connections on Workbook open. Get this VBA code now!
Learn
Excel Macro: Open a Workbook to a Specific Sheet
Sometimes you need to open your workbook be started on a specific worksheet. This simple macro can help you. Get this VBA code now!
Learn
Excel Macro: Unprotect a Worksheet on Workbook Open
Sometimes you need to unprotect the worksheets in a workbook before continuing your work, this macro maybe help you. Get this VBA code now!
Docs
Workbook.Open event
Occurs when the workbook is opened. Syntax expression.Open expression An expression that returns a Workbook object. Examples This example maximizes Microsoft Excel […]