Re: A Tricky Question! Macro & Chart

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Earl Kiosterud (nowhere_at_nowhere.com)
Date: 08/09/04 

Date: Mon, 9 Aug 2004 17:12:59 -0400

hce,

Attachments get stripped. Perhaps you can describe the situation. Or you
may send it to the heavily encrypted (<g>) email address below, and I'll
take a look.

It seems that whatever changed the order of your data points should leave
some kind of flag somewhere so the macro buttons know which is in which
position. What is changing them? 

-- 
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------
"hce >" <<hce.1aq9p9@excelforum-nospam.com> wrote in message
news:hce.1aq9p9@excelforum-nospam.com...
> Hi
>
> Sorry if my message was not clear enough...
>
> I have attached a copy of what I want to do...
>
> In Scenario 1, I have the chart plotted... and there r four buttons
> below each bar... and when I click on Macro A for Bar A, Macro A should
> run...
>
> However, in Scenario 2, I still have the same 4 bars but the order of
> the bars have changed due to a change in the values... Hence, Macro A
> originally was the first macro should be now in another position -
> where Bar A is...
>
> My problem here is that I would have to move the buttons/macros to
> their right position everytime when there's a change in the order...
>
> Hope the attached info is clear enough...
>
> Thank you for your interest...
>
> Cheers
>
>                  Attachment filename: chart.xls
> Download attachment:
http://www.excelforum.com/attachment.php?postid=642882
> ---
> Message posted from http://www.ExcelForum.com/
>

Relevant Pages

  • Re: A Tricky Question! Macro & Chart
    ... In Scenario 1, ... below each bar... ... and when I click on Macro A for Bar A, ... their right position everytime when there's a change in the order... ...
    (microsoft.public.excel.misc)
  • Re: shortcut menu (popup)
    ... Regardless of you not having changed anything to your car, ... The first thing I would ask is does your menu bar call/run a macro, ... menu bars are what we call context sensitive. ...
    (microsoft.public.access.formscoding)
  • Re: shortcut menu (popup)
    ... I had a project using Access 2000 which works fine for shortcut menu. ... Regardless of you not having changed anything to your car, ... The first thing I would ask is does your menu bar call/run a macro, ...
    (microsoft.public.access.formscoding)
  • Re: shortcut menu (popup)
    ... Regardless of you not having changed anything to your car, ... The first thing I would ask is does your menu bar call/run a macro, ... menu bars are what we call context sensitive. ...
    (microsoft.public.access.formscoding)
  • Re: Need macro help :)
    ... teleport, but clicking it does not start casting teleport, nothing ... I'd edited an old macro where the first one was a /use ... I have a bar on the ... consumables are in categories such as Food, Water, Food & Water, Buff ...
    (alt.games.warcraft)