Reputation: 759
I need an action in the shape context menu to be enabled only when there is at least one hyperlink (the "Hyperlinks" section is non-empty).
Is there a formula for this?
Upvotes: 1
Views: 804
Reputation: 415
If you mean a formula for testing if there are any hyperlinks try:
If (vsoShape.RowCount(visSectionHyperlink) > 0) Then
'Code to enable context menu
End If
Upvotes: 1