Maximizing a Form

[aharris2693]

Is there a way to maximize a form in excel upon opening it. I know in Access, codmd.maximize works, but excel doesn't seem to recognize this. Is this possible or should I just play with the height and width?
Thanks for any help

 

[xlbo]

AFAIK, excel forms don't have a maximise option I'm afraid

Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244

 

[Loomah]

Hi
There are a couple of possible workarounds but both have thier shortfalls

Private Sub UserForm_Initialize()
Me.Height = Application.Height
Me.Width = Application.Width
End Sub

Private Sub UserForm_Initialize()
Me.Width = Application.UsableWidth
Me.Height = Application.UsableHeight
End Sub

The first one only works like a maximised window if xl is maximised, the second will give positioning problems.
;-)


If a man says something and there are no women there to hear him, is he still wrong?
The faqs ma'am, just the faqs. Get the best from these forums : faq222-2244

 

[mal2ty]

Check Out thread222-576697