Excel Relationship linking Macro

Hi Nandu;
Please do not answer with "if possible". Please tell me what you want. I have not seen any thing that you want that is hard to do. I just have to understand what you want.

These are the definitions of words I will use: If these are not what you want, please let me know.

"Group" = Cells that are related to each other. List of all cells in the group will be in [How cells are linked]!Column B

"Master Cell" = the only cell that will Turn On a group. The Master Cell will have a Thick Border and bigger font, and all other cells will have thin border. The Master Cell will be listed in [How cells are linked]!Column A

"Turned On" = all cells in the group have color that you have previously selected for that group. The Master Cell has thick border and bigger font, and all other cells in that group have thin border. You "Turn On" a group by double clicking the Master Cell.

"Turned Off" = all cells in the group have default color that you have previously selected (default color can be white or gray or whatever color you want). Master Cell has thick border, all other cells have thin border. You "Turn Off" a group by double clicking the Master Cell for a different group.

"Disabled" = same as "Turned Off"


When the file opens, do you want all groups Turned On or Turned Off or left the same as when the file was closed?

When you double click an empty cell, all groups will be Turned On. Is that right?
When you Turn On a group, all other groups are Turned Off. Is that right?

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

Yes there is an easier way.
I can add a button to your menu, (or on the sheet, or right mouse button menu, or just about any place you want it) that creates a new group using the selected cell as Master Cell and using the color of the Master Cell as the color for that group.
Then when you double click any cell, it will be added to the group. If you double click a cell that is already in the group, it will be removed from the group.
When you double click the master cell again, it will stop adding cells to the group.