Archive of Mr Excel Message Board


Back to General Excel archive index
Back to archive home

Abort closing excel

Posted by Renaud on March 12, 2001 4:25 AM
Hello,

On my Auto_Close sub, on a particular test check, I have to abort exiting excel.

How do I do ?
Thank's


Re: Abort closing excel

Posted by Dave Hawley on March 13, 2001 1:26 AM

Hi Renaud


Use the Workbook_BeforeClose Event within the "ThisWorkbook" module and set the Cancel property to true to stop the workbook closing.


Dave
OzGrid Business Applications


This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.