Is there anyway to detect when closing workbook?

**VAer** · 11-01-2024, 10:53 AM

There is xlsm file on team shared drive, and I can put some code in Workbook_Open to detect when someone opens the workbook.

Is there anything like Workbook_Close to detect when someone closes the workbook?

**6StringJazzer** · 11-01-2024, 11:19 AM

yes, put in ThisWorkbook module:

Please Login or Register  to view this content.

There are built-in tools to answer this type of question

Workbook functions.jpg

**VAer** · 11-01-2024, 11:28 AM

Originally Posted by 6StringJazzer

yes, put in ThisWorkbook module:

Please Login or Register  to view this content.

There are built-in tools to answer this type of question

Attachment 882209

Thank you very much.

**6StringJazzer** · 11-01-2024, 03:06 PM

You're welcome!

If a member helped you solve your problem, consider adding to their reputation by clicking $A addreputationiconsmall.jpg below their profile in any of their posts.

Is there anyway to detect when closing workbook?

LinkBack

Thread Tools

Rate This Thread

Display

Is there anyway to detect when closing workbook?

Re: Is there anyway to detect when closing workbook?

Re: Is there anyway to detect when closing workbook?

Re: Is there anyway to detect when closing workbook?

Thread Information

Users Browsing this Thread

Similar Threads

Opening A 2nd Workbook to Retrieve Data From then Closing that Workbook

Excel 2013 not closing after closing workbook

Creating new workbook, saving as csv and then closing - but closing always fails.

[SOLVED] Closing a Workbook from another workbook: Workbooks.close error: Subscript out of range

Detect that workbook is closing (within code to keep Workbook in its own Excel instance)

closing a workbook without saving and closing a workbook with saving enabled

How can I detect .xls closing? Not BeforeClose , Like AfterClose?

Bookmarks

Bookmarks

Posting Permissions