View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ankur ankur is offline
external usenet poster
 
Posts: 43
Default Track Changes History sheet (Who changed the last cell)


Hi All,

I have a shared workbooks which records history (Track Changes) of all
change events. What I am trying to achieve to is a macro triggered by
a shortcut, which msgbox the username of the person who last changed
the cell.

The way I do it manually is I go to the history sheet and find out
this cell's address in Histroy sheet (last record) and look at the
user name.

Any help is deeply appreciated.

Regards,
Ankur