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



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