Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Modal User Form
I am trying to design a user form to function as a "Accept
our Terms" form the first time someone opens the file. I have the ShowModal Property of the form set to True and use the following code to load the form: Sub Auto_Open() If NotAccepted Then frmAgree.Show (vbApplicationModal) The form loads OK but you can then click on the underlying worksheet and work normally with the user form still open. Shouldn't this force the user form to have to be closed before the worksheet can be accessed? Thanks Jim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Userform modal | Excel Discussion (Misc queries) | |||
How do I fill a cell in a user form from a selection on same form? | Excel Discussion (Misc queries) | |||
Mode - getting bi- and multi-modal results?? | Excel Worksheet Functions | |||
Forms that are modal in 97 are not modal in 2003 | Excel Discussion (Misc queries) | |||
I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming |