Excel Relationship linking Macro

One more thing before I leave. Do you want other viewers to be able activate the cell colors? They won't be able to change the relationship, just see what it is. We would have to provide them a list of cells that activate the cell colors, but wouldn't be hard.