Specify the position of a Minimized Userform

[dlx]

Hi,
Excel 2003
I have added a Minimize button to a Userfom with this code
http://www.excelforum.com/excel-prog...userforms.html

lFormHandle = FindWindow("ThunderDFrame", Me.Caption)
lStyle = GetWindowLong(lFormHandle, GWL_STYLE)
lStyle = lStyle Or WS_SYSMENU 'SystemMenu
lStyle = lStyle Or WS_MINIMIZEBOX 'With MinimizeBox
SetWindowLong lFormHandle, GWL_STYLE, (lStyle)

The form minimizes to the lower left and covers the sheet tabs.
Is there a way to specify the position of the minimized from?

[Sean.DiSanti]

I don't believe you can change where it minimizes to, but you can hide it instead of minimizing it; maybe have a new sub:
[VBA]
Public Sub ToggleHide()
UserForm1.Visible = Not UserForm1.Visible
End Sub
[/VBA]
you can set a hotkey to that, and just
[VBA]
Call ToggleHide()
[/VBA] on your minimize button. that way whether it's minimized with button or hotkey, it's not in the way, AND you can get back to it with a keystroke

[Trevor]

I agree with sean.djsanti