user form deactivation

  • Thread starter Thread starter marwan hefnawy
  • Start date Start date
M

marwan hefnawy

when opening the "Find and Replace" dialog box in Excel 2002 I still
can edit the worksheet without the need to close the dialog box (the
dialog box wil only be deactivated but still alive)
In Excel 2000 I can not edit th worksheet as long as the "Find" dialog
box is running (i.e. it can not be deactivated).
My question is, How can I make my custom userform behaves like the Excel
2002 dialog boxes??
Thanks
 
Hi

Sub ShowMyForm()
Userform1.Show vbModeless
End Sub

HTH. Best wishes Harald
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

deactivate save changes 1
Embedded charts with events not working? 0
Excel wait for Find Replace dialog box in Word 4
Reset the macro assigned to Ctrl+F on workbook deactivate 11
How disable an Excel dialog box? 4
Which textbox am I in? 1
User created Dialog Box 1
Stopping Deactivation of a Worksheet 1

Back
Top