I have written a time sheet program that will be sent by
an employee by e-mail to one's supervisor. I need to
write a macro that causes the time sheet to track any
supervisor's changes (for auditing purposes). Is there
any way to do this besides the track changes option?

If not, what code do I use to enable the track changes
option?

How can I print a list of the changes made?

SDC

no coding for turning anything on or off with code, but my
notes on Tracking and a possible coded alternative are on
Highlight, Change Highlighting
http://www.mvps.org/dmcritchie/excel/highlite.htm
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"scrabtree23" wrote in message ...
I have written a time sheet program that will be sent by
an employee by e-mail to one's supervisor. I need to
write a macro that causes the time sheet to track any
supervisor's changes (for auditing purposes). Is there
any way to do this besides the track changes option?

If not, what code do I use to enable the track changes
option?

How can I print a list of the changes made?

SDC