Need help with Hyperlink in excel

[silversubey]

Hello All

I have an Excel 2003 worksheet that has a column of hyperlinks that point to a web-based program. The hyperlinks are dynamic and work fine. Is it possible to have Excel use Firefox to launch the hyperlinks without making it the default internet program?

Thanks.

[kadghar]

Hello All

I have an excel 2003 worksheet that has a column of hyperlinks that point to a web-based program. the hyperlinks are dynamic and work fine. Is it possible to have excel use firefox to launch the hyperlinks without making it the default internet program?

Thanks

I dont know if that's possible (but i'll stay subscribed here, in case someone else knows).

What it comes to my mind is to "redirect" the hyperlinks to a macro, and in the macro use SHELL. it might be of help. the only problem is that you'll have to find where the firefox is installed.

[silversubey]

Thanks for the help.
the hyperlinks are structured based on cell values within the spreadsheet.
I'm not sure how to put that in the macro. I'll keep trying and post if it works.

[kadghar]

...the hyperlinks are structured based on cell values ...

I'm not quite sure how to put the link to a macro inside the cell value, but you can try putting a label (from the Forms menu) and adding something like this into the click event of it:

[CODE=vb]Sub label1_Click 'and all the parameters I don't remember
Call myprocedure
End Sub[/CODE]

HTH