Have you looked at using a Worksheet_SelectionChange event procedure?
It's not clear if your open sheet is actively updating or if your shee
updates every time it is opened
--
bhofset
-----------------------------------------------------------------------
bhofsetz's Profile:
http://www.excelforum.com/member.php...fo&userid=1880
View this thread:
http://www.excelforum.com/showthread.php?threadid=38010