Form Closing Help

[RiciH83]

Hi, this may be something obvious im forgetting so wondering if you can help.

Basically i have a series of forms that when i open the first form excel hides all toolbars, scolls etc and maximises a pretty pic to be in the background while the forms are being used. When you get to the last form and click finish it closes the form and re-instates everything back again.

This is fine and dandy, not a problem.

What i need to do though is if somebody presses the "x" in top right hand corner of the form, it runs the "re-instate" code i have on the FINISH button. That way it doesnt just leave them with a big pretty picture and returns excel.

Thanks

Ric

 

[Noz2k]

If CloseMode = 0 Then 
'YourCode

maybe

alternatively I think you can disable the x button by doing

If CloseMode = 0 Then 
        Cancel = True 
        MsgBox "The X is disabled, please use a button on the form.", vbCritical 
    End If