Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. :( |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Help for old macros with Excel 2002 | Excel Worksheet Functions | |||
I deleted all macros in Excel but still get dialog box | Excel Discussion (Misc queries) | |||
Are macros created in Excel 2003 compatible with Excel 5.0/95? | Excel Discussion (Misc queries) | |||
How do I update Excel 2000 macros to work in Excel 2002? | Excel Discussion (Misc queries) |