Using a hyperlink instead of code

[Hozz]

Hi guys,

I currently have a spreadsheet with button on it, using the code, clicking the button changes to another spreadsheet.

Is it possible to assign a hyperlink to the button instead of code?

Going a step further down the hyperlink road, how do I hyperlink to a chart rather than a spreadsheet? There is no option in the hyperlink window to select charts. Only the sheets show.

 

[ADAMC]

Not sure if this is the best way to do it, but:

Is it possible to assign a hyperlink to the button instead of code?

No idea, i dont think it is, what i would do is get a picture of a button from the web, insert it into my sheet as a picture (Insert> Picture) then click the picture and create a hyperlink instead of code. Hope this makes sense.

Going a step further down the hyperlink road, how do I hyperlink to a chart rather than a spreadsheet? There is no option in the hyperlink window to select charts. Only the sheets show.

I would save the chart seperately and link to it as a document instead of trying to link to it in the same workbook. Save just the chart as chart.xls or whateve, store it somewhere and in your other workbook link to chart.xls

Hope this helps.