Automatic update pivottable in closed workbook and email macro

Hi Excel Experts,

I have a macro which update a pivot table and if there is a change in pivot table send an e-mail if not saved and closed workbook (the workbook is open automatically by windows scheduler).
The problem concern closing whole Excel 2013 window.
If there is no change in PT my workbook does not close and I see a grey window of excel and when there is a change after update and sending email, I see my pivot table in open workbook.

How sould I modified a code to closed workbook no meter if there is a change or no in PT.

Thanks for help !

Please Login or Register  to view this content.