View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Zeeb[_2_] Jim Zeeb[_2_] is offline
external usenet poster
 
Posts: 23
Default Preventing Form Dialog dismiss (Red X)

I want to detect if someone click the Red X to dismiss the form instead of my
OK or Cancel command buttons. Even better would be to prevent the form from
being dismissed in the first place.

I looked in the Object Browser for UserForm and did not find a BeforeUnload
event. I see the Terminate event, but it appears this is too late to prevent
the form from being terminated.

Is there something I'm missing?

inTHANKSadvance