LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 13
Default Minimize and Maximize Forms

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
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
minimize and maximize buttons missing KR4d Excel Discussion (Misc queries) 8 October 9th 09 03:32 PM
Shortcut key minimize/maximize druus Excel Discussion (Misc queries) 1 January 11th 08 06:51 PM
how do i minimize/maximize a workbook from vba? I want to minimize it durring processing to speed things up a bit Daniel Excel Worksheet Functions 2 July 9th 05 03:35 AM
How to get Maximize and Minimize buttons on Userform TBA[_2_] Excel Programming 1 September 9th 03 08:13 PM
Minimize workwook and then maximize UserForm Fede Querio Excel Programming 0 July 28th 03 06:44 PM


All times are GMT +1. The time now is 07:24 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"