There is a workbook event called BeforeSave. Call you macro in this event
code.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Einollah2001" wrote in message
...
How can I run a macro automatically right before saving a file. So all the
user had to do is to click on save and the macro will run.??

Thanks
E.B.