CommandEnabled Event
Occurs when the the specified Microsoft Office Web Component command is enabled.
Private Sub object_CommandEnabled (ByVal Command As Variant, ByVal Enabled As ByRef)
object A ChartSpace, PivotTable, or Spreadsheet object.
Command Required. The command that has been executed.
Enabled Required. Set the Value property of this object to True to disable the command.
Remarks
The OCCommandID, ChartCommandIDEnum, PivotCommandId, and SpreadsheetCommandId constants contain lists of the supported commands for each Web component.