According to my boss at work, an Excel sheet only containing this Macro should be automatically updating (from Bloomberg) whenever it opens:

Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel As Boolean)
  On Error Resume Next
  Dim objComment As Object
  Set objComment = Target.Cells(1, 1).Comment
  If Not objComment Is Nothing Then
    If InStr(1, objComment.Text, "Series") > 0 And InStr(1, objComment.Text, "Class") > 0 Then
      CommandBars("EwShort").ShowPopup
      Cancel = True
    Else
      Cancel = False
    End If
  End If
End Sub
Can anyone confirm that this is actually the case? And if not, might there be another way of ensuring automatic update of data from Bloomberg (not involving VBA)?

Thank you!