views:

7

answers:

0

I know how to add a link to a button in Adobe Flash...

But how exactly do I add an _onClick() event to execute a Microsoft Excel sub macro?

I have a web browser form in an excel sheet. Excel allows you to draw a browser form on the page and link it to a

page (e.g. stackoverflow.com) so stackoverflow.com will show in the browser frame.

However, I am trying to attach sub macro functions on the links within that html page.

Here is a quick run down more clear (you could easily follow the steps with Microsoft Excel)

Under Developer Tab>Insert>More Controls> and select Microsoft Web Browswer [code] Private Sub Worksheet_Activate() WebBrowser1.Navigate "http://www.chandoo.org" End Sub [/code]

With this I can upload an html page I created with flash button links, and what I would like to do is execute sub

macro codes from those links.

How exactly do I modify the code beneath to accomplish this?

[code] myBtn.onRelease = function() { getURL("http://www.stackoverflow.com;); }; [/code]