Running macro when spreadsheet is saved

[Jack77]

Hi,

Is it possible to run macro automatically when spreadsheet
is saved?

I have been trying to figure this out unsuccesfully8(

Any help would be appreciated!

 

[Frank Kabel]

Hi
have a look at the workbook_beforesave event. See
http://www.cpearson.com/excel/events.htm
for more details about event procedures

 

[Bob Phillips]

Jack,

Look at the Workbook_BeforeSave event in help.

--

HTH

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

 

[Kalle]

search in help for:

BeforeSave