Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old Car
 
Posts: n/a
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  
papou
 
Posts: n/a
Default

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
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 2 May 13th 23 11:46 AM
update row numbers after different active cells in macros followi. LMIV Excel Discussion (Misc queries) 11 February 16th 05 12:44 AM
How do I override fixed decimal place settings in EXcel 2003? jroyv Excel Worksheet Functions 2 February 11th 05 06:07 PM
Excel 2003 Forms Crash on Tablet PC all other OSs Ok JD Excel Discussion (Misc queries) 0 December 8th 04 11:26 PM
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. Cindy Winegarden Excel Discussion (Misc queries) 0 November 28th 04 12:07 AM


All times are GMT +1. The time now is 12:14 AM.

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

About Us

"It's about Microsoft Excel"