thanks for the help...but it still runs in the MASTER wb if it is the
one that's active. Your code makes perfect sense but it actually skips
the test of Yes No and always runs it. Could it be the wb name? The
actual name is Forecast Macro Master.xls. I substitued it in your code
but it just fly y without testing it.


thanks for your help


--
halem2
------------------------------------------------------------------------
halem2's Profile: http://www.excelforum.com/member.php...fo&userid=9930
View this thread: http://www.excelforum.com/showthread...hreadid=535966