Forms that are modal in 97 are not modal in 2003

O

Old Car

I developed a VB application using Excel 97. The forms are modal. In other
words, when the application is running and forms are displayed, the user can
not manipulate the worsheets directly. However, users can click on
worksheets and manipulate them when the same application is running in Excel
2003.

Is there something I can do in the application to make sure that the forms
are modal when running in Excel 2003? Thanks.
 
P

papou

Not too sure since Forms should be Modal as a default setting but you may
try:
UserForm1.Show vbModal

HTH
Cordially
Pascal
 

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

Error 400 in VB editor 3
Viewing Excel VBA-generated User Form (modal) in Word 5
Self closing "modal" window ? 4
MODAL vs. NonMODAL 5
Hide sheets and allow form 1
How do I display a (non-modal) progress message? 4
Make non-modal form an inactive window 2
AppActivate problems or is there a better way to take focus froma non modal user form 1

Top