Execute Macros through Hyperlinks.

>may I just need to wrtie the name of the macro in place of MsgBox function.
Yes - that's all you need to do
....
Case "whatever": MacroName
....

Tim
--
Tim Williams
Palo Alto, CA


<saddat@gmail.com> wrote in message
news:1137536320.917647.44220@g43g2000cwa.googlegroups.com...
> thanks Tim for your reply,
>
> could you also help me out and tell me how do I call the Macro. >
> thanks,
>
> Saddat Sarfraz
> (Saadi)
>

Sorry to trouble you again.

I am trying to run the command but nothing is happaning. I tried with
Macro as well as MsgBox Function, nothing is working.

Show the exact code which is not working.
What does it do instead of working?

tim

--
Tim Williams
Palo Alto, CA


<saddat@gmail.com> wrote in message
news:1137537988.806480.147830@g43g2000cwa.googlegroups.com...
> Sorry to trouble you again.
>
> I am trying to run the command but nothing is happaning. I tried with
> Macro as well as MsgBox Function, nothing is working.
>

Hi,
This worked:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)

Select Case ActiveCell.Address

Case "$D$8": MyMacro
Case "$D$9": MsgBox "call a different macro"

End Select

End Sub

Sub MyMacro()
MsgBox "MyMacro called"
End Sub


HTH

"saddat@gmail.com" wrote:

> Sorry to trouble you again.
>
> I am trying to run the command but nothing is happaning. I tried with
> Macro as well as MsgBox Function, nothing is working.
>
>