Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Anyone knows a fix for this? or should I use API's to disable the workbook windows? New workbook, insert a userform with following code Private Sub UserForm_Click() Dim v v = Application.GetOpenFilename If v < False Then Workbooks.Open v End Sub run the form. (MODAL) click the form and open a workbook. Excel menu;s are still disabled, but all workbook windows in the excel desktop are now ENABLED! Context menu's ARE available. try copy and paste somewhere in the newly opened workbook. and excel will crash. (XP/ 2003) (minimizing a workbook is ok. but if you close the newly opened workbook via the "X button it crashed your form. with an "automation error: invoked a disconnect" error. -- keepITcool | www.XLsupport.com | keepITcool chello nl | amsterdam |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Userform modal | Excel Discussion (Misc queries) | |||
Forms that are modal in 97 are not modal in 2003 | Excel Discussion (Misc queries) | |||
Forms that are modal in 97 are not modal in 2003 | Excel Programming | |||
Button on Userform calling GetOpenFilename | Excel Programming | |||
Excel97 Userform to be system modal/equivalent | Excel Programming |