Excel Macros, PLEASE HELP!
 

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.
:(


--
excelmacrouser
------------------------------------------------------------------------
excelmacrouser's Profile: http://www.excelforum.com/member.php...o&userid=29354
View this thread: http://www.excelforum.com/showthread...hreadid=490602

Excel Macros, PLEASE HELP!
 

I would have all the charts created on the one sheet, one on top of the
other. Then your macros just have to hide all charts and unhide the one
relevant to the link something like:

With Sheets("Sheet1")
.ChartObjects.Visible = False
.ChartObjects("Chart 1").Visible = True
End With

Hope this helps
Rowan

excelmacrouser wrote:
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.
:(