Switchboard Macro problem - Urgent!

[bronen]

I have a macro that i created to open a hyperlink. However, it opens the
link twice. How do i prevent this?

My code:

=FollowHyperlink("http://www.cnn.com") as an example.

Ben

 

[Steve Schapel]

Ben,

I saw your earlier post on the topic. If you don't get a reply to a
newsgroup post, it normally means that nobody knows the answer, or else
you haven't asked the question in a way that enables people to
understand what you are doing. Therefore, if you decide to ask again,
it is better to try and re-phrase it. In this case, I haven't been able
to imagine the context in which anyone would use an expression like
=FollowHyperlink("http://www.cnn.com")

 

[bronen]

Steve,
I am using the FollowHyperlink macro on a switchboard. I have a switchboard
that is not just a normal switchboard with buttons. You mouse over items
then click the item to open a form. What I want the FollowHyperlink to do is
open a link to a file that is somewhere on my machine. So if I have a link
for a word document, then in the switchboard I'll see the item listed, then
I'll click on it, and it'll load it.

That make sense?

Ben

 

[Steve Schapel]

Ben,

Sorry to be thick here. As far as I know, there is no such animal as a
"FollowHyperlink macro", and I do not know what you are referring to as
an "item", so I am having difficulty imagining what you have there.

However, I did test here by putting a label on a form, and entered a
FollowHyperlink function in the On Click event property of the label,
like this:
=FollowHyperlink("C:\Data\test.xls")
.... and I found that clicking on the form did open the file in Excel,
and only one copy, so could not replicate your problem of opening twice.