BeforeScreenTip Event
Occurs before a ScreenTip is displayed for an element in a PivotChart view or PivotTable view.
Private Sub Form_BeforeScreenTip(TipText As String, ByVal ContextObject As Object)
TipText The default text of the ScreenTip. Changing this argument to an empty string effectively hides the ScreenTip; changing it to any other text displays the changed text in the ScreenTip.
ContextObject The object that generates the ScreenTip.
Example
The following example hides ScreenTips for all data labels in the specified form.
Private Sub Form_BeforeScreenTip( _
TipText As String, ByVal ContextObject As Object)
If TypeName(ContextObject) = "ChDataLabel" Then
TipText = ""
End If
End Sub