An interesting graphical effect - need help understanding how this is done

[Ralph1147]

Hi,

I found a nice template for FIFA 2014 championship over here:

World cup 2014 free Excel prediction template - Spreadsheet1 - Excel Data Analytics

as you can see clicking on Groups A, B, C (the image) we are moved to another worksheet. I could do this easily using VBA, but in the source file I cannot find code that would do this, which leads me to believe this was accomplished without vba.

Does anyone know how?

 

[wigi]

That will just be a shape containing a hyperlink, whereby the hyperlink takes you to a different sheet.

 

[mole999]

you'll find some information via name manager, but the project is locked and you also have the associated add in

 

[wigi]

Well, it's not a shape but a picture with a hyperlink.

What I did not know was that if you group several pictures with a hyperlink, the hyperlink remains valid for each individual picture.
While grouping to 1 object, the hyperlinks still work when hovering over the original picture.

 

[Ralph1147]

Thanks guys! Do you know how they made sheets invisible. When I try to change the property in their spreadsheets I get a class error. Would setting the property to very hidden still allowed the hyperlinks to work?

Also, when you click one of those group tabs, they change color and ad an arrow like tip. Also would like to know how to do that

Thanks

 

[mole999]

they are offering the software for free in it beta state

 

[Ralph1147]

they are offering the software for free in it beta state

I can't install any software; I am curious how I could achieve similar effects without any extra software.

 

[wigi]

Also, when you click one of those group tabs, they change color and ad an arrow like tip. Also would like to know how to do that

As I wrote above, there are 8 sheets, 1 for each group. Each tab (group A to H) has the picture on top, and the "active" group in the picture looks different, with the arrow.

 

[wigi]

Thanks guys! Do you know how they made sheets invisible. When I try to change the property in their spreadsheets I get a class error. Would setting the property to very hidden still allowed the hyperlinks to work?

Also, the sheets are not invisible. It's just that the sheet tabs are not shown.
A hyperlink to a hidden sheet or a very hidden sheet will not work but not raise an error.
A hyperlink to a sheet and after that the linked sheet is deleted: that will raise an error when clicking the hyperlink.