dlx
11-24-2010, 01:47 PM
Hi,
Excel 2003
I have added a Minimize button to a Userfom with this code
http://www.excelforum.com/excel-programming/349283-minimize-and-maximize-buttons-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?
Excel 2003
I have added a Minimize button to a Userfom with this code
http://www.excelforum.com/excel-programming/349283-minimize-and-maximize-buttons-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?