,

Excel Tutorials – Workbook VBA Events Part 4

Workbook SheetCalculate Occasion

It will run after any of the worksheets inside this particular workbook need to be calculated. This occasion happens after the Worksheet SheetCalculate Occasion for that particular worksheet that was calculated.

Required Parameters

Sh – This parameter represents the worksheet that was calculated by the person.

Workbook SheetChange Occasion

It will run after a person edits a cell or cells inside any worksheet inside this workbook. This occasion will happen after the Worksheet SheetChange Occasion for the particular worksheet that’s being modified.

Required Parameters

Sh – This parameter represents the worksheet that was modified by the person.

Goal – The goal parameter will return the vary of the cells the place the change happens.

Workbook SheetDeactivate Occasion

It will run after any of the worksheets inside this particular workbook develop into deactivated. This occasion will happen after the Worksheet SheetDeactivate Occasion for the particular worksheet that’s being deactivated.

Required Parameters

Sh – This parameter represents the worksheet that was deactivated by the person. This parameter returns a Worksheet object to permit customers to control the occasions, strategies and properties.

Workbook SheetFollowHyperlink Occasion

It will run code when a person selects a hyperlink to comply with inside any worksheet inside this particular workbook. This occasion will happen after the Worksheet SheetFollowHyperlink Occasion for the particular worksheet that accommodates the hyperlink being adopted.

Required Parameters

Sh – This parameter represents the worksheet that accommodates the hyperlink chosen by the person.

Workbook SheetPivotTableUpdate Occasion

It will run code when a person updates a pivot desk inside any worksheet on this particular workbook. This occasion happens after the Worksheet PivotTableUpdate Occasion for the worksheet that accommodates the pivot desk that’s up to date.

Required Parameters

Sh – This parameter represents the worksheet that accommodates the up to date pivot desk. This parameter returns a Worksheet object to permit customers to control the occasions, strategies and properties.

Workbook SheetSelectionChange Occasion

It will run code when a person selects a brand new vary inside any worksheet on this particular workbook. This occasion will happen after the Worksheet SheetSelectionChange Occasion for the worksheet that accommodates the newly chosen vary.

Required Parameters

Sh – This parameter represents the worksheet that accommodates the vary that was chosen. This parameter returns a Worksheet object to permit customers to control the occasions, strategies and properties.

Goal – The goal parameter will return the vary of the cells of the brand new choice.

Workbook WindowActivate Occasion

It will run any time this particular workbook window is activated.

Required Parameters

Wn – The wn parameter represents the activated window as an object. This parameter returns a Window Object so customers can manipulate the strategies and properties of that particular window.

Workbook WindowDeactivate Occasion

It will run any time this particular workbook window is deactivated.

Required Parameters

Wn – The wn parameter represents the deactivated window as an object. This parameter returns a Window Object so customers can manipulate the strategies and properties of that particular window.

Workbook WindowResize Occasion

It will run any time this particular workbook window is resized.

Required Parameters

Wn – The wn parameter returns the resized window as an object. This parameter returns a Window Object so customers can manipulate the strategies and properties of that particular window.

Leave a Reply

Your email address will not be published. Required fields are marked *

ITIL Service Management – Bible For Managing Information Technology

Boost Computer Security With Anti-Vermin Spyware Removal Software