You can link a tab yourself with two clicks... click on the desired cell, hit the = key, then click on the desired tab.... done... You can then add any formula you want after that in the top window with the active cell showing.rgwells said:Does anyone have an excel macro that would link a tab name to text in a cell on a worksheet