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...