type this code in workbook's before close event
now when you will close the workbook it will not prompt to save the workbook but it will save all the changes u made in workbook before closing.Please Login or Register to view this content.
type this code in workbook's before close event
now when you will close the workbook it will not prompt to save the workbook but it will save all the changes u made in workbook before closing.Please Login or Register to view this content.
Last edited by Paul; 01-11-2013 at 03:38 PM.
Thanks for this tip.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Wow! Thanks for this! :D
Very useful, to extend the idea a bit:
could be used if you had a large workbook which took some time to save, as it would only do it if the workbook was not already saved.Please Login or Register to view this content.
Also:
Would do the opposite, and close the workbook without saving/prompting. Althogh I suspect there are other ways of doing this, maybe using displayalerts = false.Please Login or Register to view this content.
great tip, thanks
is this a great tips did you try it, maybe i will try before i said this is great shared ideas, but for the above post i am positive this is working..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks