Thank you that was really useful to know, but is there a way i can ge
the code to run without attaching it to a button.

So if i type 1 into cell A1 and press enter the macro wil
automatically run?

Regards

Pet

--
Message posted from http://www.ExcelForum.com