Workbooks.close SaveChanges:=True question

[TFlemingX]

This might be a dumb question, and searching I can't find the answer. As everything is related to the "prompts."

What I am wondering is if there is a way to suppress the save progress/cancel box that comes up while the workbook is saving. There are no standard prompts to deal with. I've tried using the .screenupdating and .displayalerts (Both set to false before close and back to true after close). But it is still shown.

Like I've said, this may be one of the few displays you can't suppress. But wanted to see if I was missing another option. Thanks.

[6StringJazzer]

I have not experimented with this but you can try this. Instead of checking for changes on closing, force it to save first:

Please Login or Register  to view this content.

I think the user will not see any progress or dialog box in this case. This assumes that you don't mind saving it even if there have been no changes.

[TFlemingX]

I'll try the tweak and see. No issues saving, as there will be for sure changes, as it opens, adds data, then closes/saves.

Edit: Nope, still get those "progress bars" on save.

[6StringJazzer]

This will do it, I tested this time:

Please Login or Register  to view this content.

I showed MyWorkbook as an object for an external workbook. If you are closing the workbook containing the code, then you can use ThisWorkbook.

[TFlemingX]

ok, thanks for the help