I want to create a macro to run when users of a shared woorbook hit save or
save as, as a way of protecting the master data set. My data will contain
many columns such as standard cost and selling prices, i only want to allow
the save if they have not corrupted formatting or data validation. Is this
possible?

I've made a start with a MsgBox code but not sure how to proceed...