Hyperlink from an image

[chriswilko]

Hi,
I have a hyperlink that runs when the image is clicked.
I'd like to change this to take to a different website based on a condition
(like through the hyperlink formula). Can I do this and keep the image
rather than have a hyperlink in a cell.
Thanks

 

[Gary''s Student]

There are several ways to accomplish this. The easiest way is to assign a
macro to the image instead of a hyperlink.

The macro would perform the hyperlink based upon conditions in the worksheet.

 

[chriswilko]

Is there a way without using vba? - the spreadsheet will be truned to an xml
file at the end and wont be able to run macros.

 

[Gary''s Student]

I don't know of any way that avoids VBA....sorry