Author Topic: Count Hyperlinks? Protect Hyperlink.OffPageReference?  (Read 1728 times)

0 Members and 1 Guest are viewing this topic.


  • Newbie
  • *
  • Posts: 7
Count Hyperlinks? Protect Hyperlink.OffPageReference?
« on: August 01, 2013, 04:13:42 PM »

I have this ever changing 30-some page diagram, I have a fairly complex master-in-the-works that has multiple color by value (thank you John Goldsmith for the tutorial!) and I even managed to make it that if there is an off-page reference it shows the destination page number and the conditional on shape geometry, the title ... one problem, if you use the menu to edit hyperlinks and delete the off-page reference the formulas break and can't recover.

I had a few formulas that depended on the off-page that used to work but now are broken:
  =IF(ISERROR(GETREF(Hyperlink.OffPageReference))," ",GETREF(Hyperlink.OffPageReference))
  =IF(ISERROR(GETREF(Hyperlink.OffPageReference)),TRUE,SETF(GetRef(Prop.GoToPageNo),"iferror(Pages["&Prop.GoToPageName&"]!ThePage!PAGENUMBER(),"" "")"))

I saw a similar post and the answer is to the one was that the shapes are not self aware 

Is there a way to use =CALLTHIS(".rowExists",0,0) to determine if there is at least one hyperlink?
Is there a way to protect the Hyperlink.OffPageReference row so it cannot be deleted?

I'm trying to use just the shapesheet, no vba, using Visio 2010



  • Hero Member
  • *****
  • Posts: 1061
Re: Count Hyperlinks? Protect Hyperlink.OffPageReference?
« Reply #1 on: August 02, 2013, 12:58:38 AM »
I can't answer the complete quesion, but I can at least tell you that you can't use Callthis() because that calls a CBA macro and you state in your post, that you don't want to use VBA, so that's no help here I guess.