you can put your code within the following IF. This checks for a chang
in cell A1

sub worksheet_change()

if target.row = 1 and target.column=1 then

you code here

end if
end sub

- Manges

--
mangesh_yada
-----------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...fo&userid=1047
View this thread: http://www.excelforum.com/showthread.php?threadid=27445