Thread: Forms that are modal in 97 are not modal in 2003
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
papou papou is offline
external usenet poster
  
Posts: 110
Default Forms that are modal in 97 are not modal in 2003
Not too sure since Forms should be Modal as a default setting but you may
try:
UserForm1.Show vbModal

HTH
Cordially
Pascal

"Old Car" a écrit dans le message de
news:X0Fbe.12829$Nc.10184@trnddc09...
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.




Reply With QuoteReply With Quote