You can have a macro change when you change the selection on the same sheet or
change sheets or change workbooks.

You can read more about these kinds of events at:
Chip Pearson's site:
http://www.cpearson.com/excel/events.htm

David McRitchie's site:
http://www.mvps.org/dmcritchie/excel/event.htm

Daniel Lees wrote:

Like in access u can get it to run a macro automatically when a cell is
exited, is this possible in excel, e.g. say when the cursor leaves cell C4
run a specific macro?

Cheers

Danny

--

Dave Peterson