Results 1 to 89 of 89

Excel Relationship linking Macro

Threaded View

  1. #22
    Forum Expert
    Join Date
    03-31-2009
    Location
    Barstow, Ca
    MS-Off Ver
    Excel 2002 & 2007
    Posts
    2,164

    Re: Excel Relationship linking Macro

    Hi Nandu;
    For the crash, if the attachments is not sucessful, double click on the empty cell, to see the crash
    Fixed double click on empty cell.
    When you double click an empty cell, you want to have all lists colored with the border you chose for each list. Is that right?
    When you double click the master cell of a list, you want all other lists to be white, except the one you double clicked. Is that right?

    What cell was earlier double clicked. What did it do? How did you try to reset the color? "
    -- step 1: Double click B13, then click F2, you will see cell linkage colors, double clicked for B13 are not reset to saved colors.
    Ok let's try this. Maybe this will help me understand what you want.
    I am using Relations 6 (the last file I uploaded to the forum).
    This is what I do and the results.

    1) When the file opens, all the groups are colored except 1 (B13:E13 have white cell color and no borders).
    My Action - (Results)
    2) Double Click B13 - (B13:E13 are colored. B13 has thick border. All other cells - no changes)
    3) Click F2 - (Nothing happens)
    4) Double Click F2 - (F2, B4:H4, D8:H8, F11, H11 all change to white cell color, and borders stay the same. All other cells - no changes)
    5) Double Click F2 again - (F2, B4:H4, D8:H8, F11, H11 all get colored.)

    Now you tell me what you want to happen when you 1) Double Click B13, 2) Click F2, 3)Double Click F2, 4) Double Click F2 again.


    "Do you mean the border was a dotted line? Do you want the borders of all the cells to be saved also?"
    -- Yes sir. i want to present a logical groups in the borders.
    Will all the cells in 1 group always have the same border style? Or will the master cell have a different border than the rest of the group?
    Will you manually put the border on the cells in [How Cells Are Linked]!C5:C19? Or do you want to manually put the borders on [Cell Links]!cells and the program saves them (that way each cell can have a different border if you want)?
    Last edited by foxguy; 06-22-2010 at 09:58 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1