WorkbookBase.New Event
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Occurs when a new workbook is created.
public:
event Microsoft::Office::Tools::Excel::WorkbookEvents_NewEventHandler ^ New;public event Microsoft.Office.Tools.Excel.WorkbookEvents_NewEventHandler New;member this.New : Microsoft.Office.Tools.Excel.WorkbookEvents_NewEventHandler Public Custom Event New As WorkbookEvents_NewEventHandler Event Type
Examples
The following code example demonstrates a handler for the New event. The event handler maximizes the Microsoft Office Excel application window when a new workbook is created.
This example is for a document-level customization.
private void WorkbookNew()
{
this.New +=
new Microsoft.Office.Tools.Excel.WorkbookEvents_NewEventHandler(
ThisWorkbook_New);
}
void ThisWorkbook_New()
{
this.Application.WindowState = Excel.XlWindowState.xlMaximized;
}
Sub ThisWorkbook_New() Handles Me.New
Me.Application.WindowState = Excel.XlWindowState.xlMaximized
End Sub