JE,

i can manually open the track changes function and create a history page,
but this wil be used by people that have limited experience with excel. i
wanted to make a function button that would generate the history list
automatically if possible.

"JE McGimpsey" wrote:

Instead of macros, try using change history (see "Turn on the change
history for a workbook" in XL Help).

In article ,
BBB wrote:

hi,

does anyone know if it is possible to write a marco to track the changes in
an excel document? if so do you know where i could find some information on
this or help me write this.

i want to create a function button that will create a new page to display
all the changes made to a document in say the last month. i am having
difficulties making this work as i can not write macros in a shared
workbook...