If you share the workbook under tools, there is an option to track history.

sharing the workbook does impose some limitations on what can be done with
it.

See help for details.
Otherwise, look at the Change event and selectionchange event

http://www.cpearson.com/excel/events.htm
Chip Pearson's page on events.

--
Regards,
Tom Ogilvy


"Rory" wrote in message
...
I wanted to keep a small log of what shhets and possibly what cells
changed
each time the workbook is opend. The reason for this is that as a teacher
I
want to see how the students interact with the sheets when solving
problems.

I ahve already ebeen able to incorporate the get network username and
computername API calls, but I can't seem to figure out how to record the
changes.

Any Ideas