Workbook Open Event This event will run every time this specific workbook is opened.
Workbook PivotTableCloseConnection Event This event will run every time a pivot table connection is closed within the specific workbook.
Required Parameters Target - The target parameter represents the pivot table with connection being closed.
This parameter returns a Pivot Table object to allow users to manipulate the events, methods and properties.
Workbook PivotTableOpenConnection Event This event will run every time a pivot table connection is closed within the specific workbook.
Required Parameters Target - The target parameter represents the pivot table with connection being opened.
This parameter returns a Pivot Table object to allow users to manipulate the events, methods and properties.
Workbook SheetActivate Event This event will run every time any worksheet within the specific workbook is activated.
This event will occur after the Worksheet SheetActivate Event for the worksheet that is activated.
Required Parameters Sh - The sh parameter returns the worksheet that was activated by the user.
This parameter returns a Worksheet object to allow users to manipulate the events, methods and properties.
Workbook SheetBeforeDoubleClick Event This event will run after a user double clicks within any of the worksheets in this specific workbook.
This event will occur after the Worksheet SheetBeforeDoubleClick Event for the worksheet that is double clicked.
Required Parameters Sh - The sh parameter returns the worksheet that was double clicked by the user.
This parameter returns a Worksheet object to allow users to manipulate the events, methods and properties.
Target - The target parameter will return the range of the cell closest to where the mouse is pointing when the double click occurs.
Cancel - The cancel parameter is Boolean data type set to return either true or false.
By default the cancel parameter will return a value of false when the double click occurs.
If the cancel parameter is set to a value of True then the default double click process will not occur.
Workbook SheetBeforeRightClick Event This event will run after a user right clicks within any of the worksheets in this specific workbook.
This event will occur after the Worksheet SheetBeforeRightClick Event for the worksheet that is right clicked.
Required Parameters Sh - The sh parameter represents the worksheet that was right clicked by the user.
This parameter returns a Worksheet object to allow users to manipulate the events, methods and properties.
Target - The target parameter will return the range of the cell closest to where the mouse is pointing when the right click occurs.
Cancel - The cancel parameter is Boolean data type set to return either true or false.
By default the cancel parameter will return a value of false when the right click occurs.
If the cancel parameter is set to a value of true then the default right click process will not occur.
Workbook PivotTableCloseConnection Event This event will run every time a pivot table connection is closed within the specific workbook.
Required Parameters Target - The target parameter represents the pivot table with connection being closed.
This parameter returns a Pivot Table object to allow users to manipulate the events, methods and properties.
Workbook PivotTableOpenConnection Event This event will run every time a pivot table connection is closed within the specific workbook.
Required Parameters Target - The target parameter represents the pivot table with connection being opened.
This parameter returns a Pivot Table object to allow users to manipulate the events, methods and properties.
Workbook SheetActivate Event This event will run every time any worksheet within the specific workbook is activated.
This event will occur after the Worksheet SheetActivate Event for the worksheet that is activated.
Required Parameters Sh - The sh parameter returns the worksheet that was activated by the user.
This parameter returns a Worksheet object to allow users to manipulate the events, methods and properties.
Workbook SheetBeforeDoubleClick Event This event will run after a user double clicks within any of the worksheets in this specific workbook.
This event will occur after the Worksheet SheetBeforeDoubleClick Event for the worksheet that is double clicked.
Required Parameters Sh - The sh parameter returns the worksheet that was double clicked by the user.
This parameter returns a Worksheet object to allow users to manipulate the events, methods and properties.
Target - The target parameter will return the range of the cell closest to where the mouse is pointing when the double click occurs.
Cancel - The cancel parameter is Boolean data type set to return either true or false.
By default the cancel parameter will return a value of false when the double click occurs.
If the cancel parameter is set to a value of True then the default double click process will not occur.
Workbook SheetBeforeRightClick Event This event will run after a user right clicks within any of the worksheets in this specific workbook.
This event will occur after the Worksheet SheetBeforeRightClick Event for the worksheet that is right clicked.
Required Parameters Sh - The sh parameter represents the worksheet that was right clicked by the user.
This parameter returns a Worksheet object to allow users to manipulate the events, methods and properties.
Target - The target parameter will return the range of the cell closest to where the mouse is pointing when the right click occurs.
Cancel - The cancel parameter is Boolean data type set to return either true or false.
By default the cancel parameter will return a value of false when the right click occurs.
If the cancel parameter is set to a value of true then the default right click process will not occur.
SHARE
