How do I create minimize and restore buttons on a user form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Excel 2003 SP1 (part of Office Professional Edition 2003)

I would like to understand how to create a user form in Visual Basic for
Applications that contains not only the Close Button in the Title Bar (the
default), but also the Minimize and Restore Buttons as well.

Additionally, is it possible when the user maximizes a user form (by
clickiing the maximize button) that all subsequent forms are automatically
maximized when the application opens them (i.e. form.Show)? In other words,
without the user having to click the maximize button on each of the user
forms.
 
Additionally, is it possible when the user maximizes a user form (by
clickiing the maximize button) that all subsequent forms are automatically
maximized when the application opens them (i.e. form.Show)? In other
words,
without the user having to click the maximize button on each of the user
forms.
Click to expand...

You would have to save the setting somewhere and then when the workbook
opens retrieve the setting so that when you call show inside the open event
you can refrence the setting and maximize the form.
 
Back
Top