Hi Excelperts, there are several macros I created that run automatically when the workbook is opened. I have also some on closing the workbook. But I couldn't figure out yet how to make a macro run when the file is saved. To be very specific: if you close the file without saving, it should 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 advance hamster --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
