Results 1 to 89 of 89

Excel Relationship linking Macro

Threaded View

  1. #23
    Registered User
    Join Date
    09-17-2009
    Location
    New Zealand
    MS-Off Ver
    Excel 2003
    Posts
    48

    Re: Excel Relationship linking Macro

    Hi Guru FoxGuy,

    Thank you for the time Guru.
    Please find the answers in Royal Blue.

    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?
    -- Yes
    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?
    -- Any color option if possible to provide like grey etc would be treat to see.

    1) When the file opens, all the groups are colored except 1 (B13:E13 have white cell color and no borders).
    --- This is because colors are not assigned so Expected behaviour
    My Action - (Results)
    2) Double Click B13 - (B13:E13 are colored. B13 has thick border. All other cells - no changes)[/SIZE]
    -- Not Expected Behaviour; All other cells should go be to a "if possible default color grey or something to show they are disabled, if difficult, white is fine" retaining the borders formatting
    3) Click F2 - (Nothing happens)[/SIZE]
    -- Single click so expected Behavior
    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)[/SIZE]
    -- Not expected; Double click on F2 will show F2 cell relationship as defined. If already selected, no change. Here it is assumed user double clicks on cell he wants to see the relationship.Rest every cell should be to default color "grey or color of choice" if difficult then white is fine, retaining the border fomatting.
    5) Double Click F2 again - (F2, B4:H4, D8:H8, F11, H11 all get colored.)[/SIZE]
    -- If already selected to display relation then No change, If F2 is double clicked while other cell is ex B13 cell relation is on, then show F2 relationship.

    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?[/SIZE]
    -- Master cell, i assume is the cell double clicked, to let user know which cell relation they are seeing should be Thick Border, with bigger font.

    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)?[/SIZE]
    -- Not sure if there can be easier way, i was manually putting the formatting in the cell saved coloumn along with color and i am manually adding the cell numbers. If there is easier way that would be great but may be step by step..

    Once again Thanking you a ton
    Nandu
    Last edited by shg; 06-23-2010 at 10:14 AM.

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 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