Hello all, i'm new to this forum, so could someone please help me! i'm doing a project for university which involves me having to create macros in excel.
Here is the problem, i have 10 links on the left side of my worksheet. which i need to assign macros to, these macros have to link to various charts, objects etc which are kept in additional worksheets in the same file. anyway i can easily assign the macro to go to another worksheet to display that chart, but how do i assign the macro so that once clicked the chart APPEARS in the current worksheet, so the chart sits to the right of the links, and then when a new link is clicked, the next chart is inserted in place of the old chart.
please somebody help me, because i'm sure this will end up being an easy problem! i'm just not that well experienced with excel.
thank you everybody.