Also,
http://www.cpearson.com/excel/events.htm

Chip Pearson's page on events.

--
Regards,
Tom Ogilvy

"Quaisne" wrote in
message ...

I have been asked the following by sa friend. I do not know the answer

"does anyone know how to write what i think is called an "event macro"

let's say that i have a simple spreadsheet that adds up a column of
numbers... i want to write a macro that will automatically run another
macro (say one that colours in a certain cell a particular colour)
whenever the subtotal goes above a certain level.

note that i know how to use conditional formatting etc, the above
example is very much a simplified version of what i'm trying to do -
the second macro in question is actually a goalseek in another part of
the workbook.

thanks! "

Can anyone help?


--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile:
http://www.excelforum.com/member.php...o&userid=28052
View this thread: http://www.excelforum.com/showthread...hreadid=487572