$$Excel-Macros$$ Re: Autorun a macro on save

2009-04-13 Thread Hamster
Thanks, Dave, that's what I was looking for! On 3 Apr., 06:54, Dave Bonallack wrote: > Hi Hamster, > > If you go to the Workbook window of the VBA, where your Workbook Open macros > live, set the left drop-down to Workbook, then in the right drop-down, > select:   BeforeS

$$Excel-Macros$$ Autorun a macro on save

2009-04-02 Thread Hamster
d not run, only when the file is saved. This is when you close and save in one step or when you save it and continue to work on it. I've tried workbook_save, on_save, auto_save. but it didn't work out. So, any hint how to do it? Thanks in