• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 4050
  • Last Modified:

Visio 2013 - VBA question - Double-click a shape and open browser/download a file

When I double-click a shape I would like to have a browser open up and hit a particular web page.
What is the code to do this?

When I double-click a shape I would like to have a browser open up and download a particular file.
What is the code to download a file which is located at: http://www.site.com/stuff.pdf
0
brothertruffle880
Asked:
brothertruffle880
1 Solution
 
Rgonzo1971Commented:
Hi,

to run a macro when dbl-clicking a shape

refer to http://msdn.microsoft.com/en-us/library/office/ff765424(v=office.15).aspx

EDIT
to download a file from an URL pls try

http://www.experts-exchange.com/Database/MS_Access/Q_26287511.html

Regards
0
 
Scott HelmersVisio Consultant, Trainer, Author, and DeveloperCommented:
Two options:

1) If having the user type Ctrl+click instead of double-click is OK, then just add a hyperlink to the shape via the hyperlink dialog (Ctrl+K).

2) But if you want the user to double click, you can actually accomplish that without a macro because every Visio shape has a built-in double click event. You can set the event for many purposes by selecting the shape, clicking the Behavior button on the Developer tab, and then clicking the Double-Click tab.

In this case, however, you can't set a link to a URL from the UI. Instead, you just need to place a formula containing the HYPERLINK() function into the shape's EventDblClick cell in the ShapeSheet:
-- turn on the Developer tab if it's not already
-- right-click the shape and select Show ShapeSheet
-- scroll down to the Events section
-- type this formula into the EventDblClick cell
        =HYPERLINK("http://www.site.com/stuff.pdf")

There's an example below.event double-click cell There are additional options for the HYPERLINK() function as documented in the Visio help text.
0
 
brothertruffle880Author Commented:
Scott:
I love you!  That was the answer I was looking for!!!!  That shapesheet tweak is what I needed!


bt
0

Featured Post

2017 Webroot Threat Report

MSPs: Get the facts you need to protect your clients.
The 2017 Webroot Threat Report provides a uniquely insightful global view into the analysis and discoveries made by the Webroot® Threat Intelligence Platform to provide insights on key trends and risks as seen by our users.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now