Office Script Change Log

[VBA learner ITG]

HI,

not sure if this is the correct place to post.

I need an office script to create a change log because users are accessing the file by the web browser the VBA code now doesn’t work which does exactly the below.

Date and Time
Cell that was changed.
Old Value
New Value

Hopefully, someone has had a similar problem and solution.

 

[ExcelToDAX]

There isn't a Worksheet_Change event in Office Scripts. In Excel Online (not desktop app), you can go to Review > Show Changes and it will give you the information you need. It has all of the information you specified such as Date and Time, Cell that was changed, Old Value, and New Value

 

[VBA learner ITG]

There isn't a Worksheet_Change event in Office Scripts. In Excel Online (not desktop app), you can go to Review > Show Changes and it will give you the information you need. It has all of the information you specified such as Date and Time, Cell that was changed, Old Value, and New Value

Thank you for replying, I agree this is the only solution for Excel Online., Hopefully, in due course they can export the online change log to excel worksheet.