View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter[_68_] Peter[_68_] is offline
external usenet poster
 
Posts: 2
Default how to quit in BeforeClose

Hi.

(Excel 2010)
I need to check if the user has changed the name at the actual sheet
before the workbook is closed.

In my sub Workbook_BeforeClose(Cancel As Boolean)
I have a YesNo box. The intention is, that if the user select No the
workbook shall remain open, e.g. the sub shall not be executed.

How do I do ?

Regards

Peter