you can use a comand button and under this button the code can be added.or
assign a macro
see help under <type of buttons etc

--
remove $$$ from email addresss to send email

"TUNGANA KURMA RAJU" wrote in
message ...
how to add and activate a worksheet formula in a cell through a control
tool
button.any article for this topic.