Difficult to see what problems you'd be having. There is a before save
event that works fine.

You need to post your actual code.

Have you tried stepping through the code  to see where it fails?

However, are you talking about doing the save from VBA code? If so, I don't
think it will trigger  this event  from VBA, because you can simply write  the
code you want just before your save. If you like, you can call the before
save event subroutine from your code.