OWC11 - PivotTable: Hyperlinks

T

Tony Bull

Greetings all,

In OWC10, if you set a field as a Hyperlink, when you click on the link, a
new window is opened automatically. That's not the case in OWC11 (I guess
someone forgot...)

So, according to the documentation, you can set a boolean value using the
'Follow' property in order to get this functionality. First you have to
make sure that the field is a hyperlink, though, which you can do with
IsHyperlink.

Again, according to the documentation, the following should make the value I
click on in .FieldSets("Customer").Fields("Address") open in a new window:

..FieldSets("Customer").Fields("Address").IsHyperlink = True
..FieldSets("Customer").Fields("Address").Hyperlink.Follow = True

....but when I try to open the page containing the script, I get a VBScript
error saying that the 'Hyperlink' property isn't supported.

Any suggestions are appreciated,

Tony B.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top