Hyperlink a Visio shape to a worksheet

[tmi!tmi!]

I have a Visio diagram that represents the computers in ou
computer/server room. I want to create hyperlinks from each of th
shapes that represents a server (for example) to a correspondin
worksheet in a workbook.
I can get the hyperlink to open the workbook, but I can't figure ou
how to drill down to the specific worksheet for a particular server.

Thanks in advance,

Jef

 

[Frank Kabel]

not tested but try adding the sheet name with
workbookpath+name#sheet1

 

[Jon Peltier]

Frank -

I tried it, and the OP must have tried it. You can type in the sheet
name, but you get an error when the file opens.

Then after five minutes in Visio (doubling the time I've spent in Visio
all year), I went into the Visio VBA object model. I figured a click on
the shape would do it, and in VBA open the workbook and tab to the
proper sheet. But I couldn't find any object with a simple click event.

- Jon

 

[Frank Kabel]

Hi Jon
thanks for the update. I'll try it by myself (don't have Visio on my
laptop so I have to get my work computrer...)

 

[tmi!tmi!]

Hi,

Just wanted to let you know that I figured out a workaround.

I saved each of the server info worksheets as web pages, and linked th
corresponding Visio objects to their web pages.

Unfortunately, if I update any server info, I have to re-save th
worksheet(s) and replace the old web page(s).


Thanks for your assistance.

Jeff ;