ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatically closing workbook (https://www.excelbanter.com/excel-programming/359275-automatically-closing-workbook.html)

zapszipszops[_4_]

Automatically closing workbook
 

Hi Everyone,

I need some help. I have a master workbook that opens a summary
workbook. I would like to be able to automatically close the master
workbook when the summary workbook is closed. (the only thing the
master workbook does is open the summary workbook and the corresponding
workbooks to update the linked information).

Thanks,
Julie


--
zapszipszops
------------------------------------------------------------------------
zapszipszops's Profile: http://www.excelforum.com/member.php...o&userid=33217
View this thread: http://www.excelforum.com/showthread...hreadid=534197


Ivan Raiminius

Automatically closing workbook
 
Hi Julie,

add:

thisworkbook.close savechanges:=false

to the end of code you have in master workbook.

Regards,
Ivan



All times are GMT +1. The time now is 12:01 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com