Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
If I want to interact with other applications or other
workbooks when my data input form is used, I know I must make the form modeless, but how do I install Minimize and Maximise buttons in the form title bar? When resuming use of a modeless form, I have found if I do not close other workbooks or do not activate the 'parent' workbook then actions on the form which get data or write data are likely to cause an error. I presume this is because references to the 'parent' workbook are incomplete if all my code has been written using just Sheets(1) notation etc without being prefixed by the workbook name ie WBook1.Sheets(1). Must I prefix all my Sheets references to be safe, or, is it possible to use a mouseclick event (or maximize event) on the form to activate the wbook automatically? I would appreciate some help on this as I have found it difficult to understand the code on Stephen Bullen's FormFun example despite it being well commented. T.I.A. Geoff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
minimize and maximize buttons missing | Excel Discussion (Misc queries) | |||
Shortcut key minimize/maximize | Excel Discussion (Misc queries) | |||
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit | Excel Worksheet Functions | |||
How to get Maximize and Minimize buttons on Userform | Excel Programming | |||
Minimize workwook and then maximize UserForm | Excel Programming |