Use the BeforeSave event

Not familiar with events? See Chip Pearson's page on the topic

http://www.cpearson.com/excel/events.htm

--
regards,
Tom Ogilvy


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.