Does anyone know if there is a way to override the Excel Save command with a VBA macro IN A CENTRAL WAY???
"IN A CENTRAL WAY" - as apposed to changing the macro assignment for each save button (in file/save menu, in the save standard toolbar button, in ctrl+s).
This method seems not to fit, because:
1) I might "forget" another place that invokes the Save function, in which my macro will not be called, and I do want all save operations to "pass through my macro"
2) This method makes me manage the enable/disable state of the buttons I override; For example, if I assign my macro to the save toolbar button, then when there is no workbook open, this button remains enabled.