On Jul 14, 7:49*am, Peter wrote:
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

As ALWAYS, post your efforts for comments and suggestions.