I don't know what event you could possibly use, but there are other ways to
run macros:
http://www.officearticles.com/misc/m...ica tions.htm
************
Anne Troy
www.OfficeArticles.com

wrote in message
ps.com...
Hi,
Typically when I use VBA I tend to put a button on a sheet. I do
this to control the macro execution. Most of the macros I'm writing
will take information that is pasted into a spreadsheet from another
spreadsheet and then manipulate the data into usable data. The original
spreadsheet is created from exported data from another program. My
question is is there an event I can use to control the execution or is
the cmd button the best way.