I've worked this out now. Needed to use Public Sub and ActiveSheet to
get it to work.

thanks


--
bluegnu
------------------------------------------------------------------------
bluegnu's Profile: http://www.excelforum.com/member.php...o&userid=36108
View this thread: http://www.excelforum.com/showthread...hreadid=560153