Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Forms that are modal in 97 are not modal in 2003

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.


  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.programming
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Userform modal Dave K[_3_] Excel Discussion (Misc queries) 1 April 9th 10 07:41 AM
Forms that are modal in 97 are not modal in 2003 Old Car Excel Discussion (Misc queries) 1 April 27th 05 08:25 AM
Modal Forms MJRay Excel Programming 1 March 8th 05 05:09 PM
Non-Modal InputBox? NooK[_38_] Excel Programming 3 July 9th 04 04:58 PM
Modal oddity Ken McLennan[_3_] Excel Programming 2 May 27th 04 06:49 AM


All times are GMT +1. The time now is 05:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"