VBA Script in regards to Audit trail

Hi all,

A newbie to the forum and excel/vba in general here.
I have an audit trail which the user inputs manually any changes they make, the workbook has over 15 sheets so it's quite sizeable..
My question is; is there any potential to use VBA to give a prompt incase someone forgets to write the corresponding change in the Audit trail.

E.g. makes changes in Wksheet 1, 2 and then goes to save without writing the changes in the audit trail. It would just be a prompt nothing more.

Best,

C