0

I have shapes that I want to change the format based on if they contain a hyperlink. This question solves this with VBA, but I'm wondering if this is possible with shapesheets only.

It seems to be possible to check if Hyperlink.Row_1 exists. But as soon as the hyperlink is removed, the Hyperlink.Row_1 disappears with it, and any formula referencing that row are deleted as well. Even worse: if you add a new link, it's added on Hyperlink.Row_2.

So now I'm hoping there's a function that checks for hyperlinks that I've missed.

Michiel
  • 57
  • 1
  • 6

1 Answers1

0

I'm wondering if this is possible with shapesheets only

Sorry, It is impossible without VBA!

Surrogate
  • 1,466
  • 2
  • 11
  • 13