Minggu, 04 Januari 2015

I understand what those parameters are useful for, I just wonder (same as for the Workbook_beforeclose), why the parameters are required.

But since I wrote my first post (or better said the second, where I made the correction), I remembered that if I wanted something to be done, I had to write application.run referring to another module.sub, and not inside the workbook code sheet.

So now, I can turn off the calculations before I save.

And restore them before close.

But anyway, I might not need it anymore, because I think that when I wrote this code, EVERYTHING was so slow.

After exiting Excel et restarting the computer, saving wasn't that bad even with calculations…

False when the event occurs. If the event procedure sets this argument to True, the workbook isn't saved when the procedure is finished.

More than once I have to prevent saving a document because some conditions were not met. So If condition is not met then put True as second parameter. If SaveAsUI = True the SaveAs dialog box is shown.

---------------------------------- Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.