Tick box on workbook close

[mook25]

Hi All,

I've done a search of the forums and can't seem to find what i am looking for.

I need a check box to appear when a user goes to close the workbook which says some thing like, "have you booked with WFP?" there would then be yes or no option. If the user were to click yes then the workbook would close but if they were to click no then a another message box would appear that would say, "please book with WFP before closing this workbook", this box would simply have an ok button on it which the user would click and the workbook would remain open.

I hope this makes sense but if you nered any more information then please let me know.


thanks

[Andy Pope]

if you wanted a checkbox you would need to use a userform.
Why not simply ask the question, which has a yes/no answer

Please Login or Register  to view this content.

code goes in the Thisworkbook object of the workbooks project.

[mahaveersomani]

use the following code

If it was really helpful to you then dont forget to hit * button for user reputation

Regards
CA Mahaveer Somani
9785216211

[mook25]

Thanks both, worked perfectly. I'll give you both some rep.