UserForm_Layout code Me.Move 0, 0 don't work
On my XP system running Office2003 I use the below code to stop anyone
from dragging my UserForm thus exposing Excels menus. All works well on the XP machine but does not snap the form back to 0,0 on a machine running Win2000 and Excel97. WHY?????? Private Sub UserForm_Layout() Me.Move 0, 0 End Sub Is there other ways to accomplish this goal. Rick |
UserForm_Layout code Me.Move 0, 0 don't work
In help for the Layout Event in xl97 it says:
Occurs when a form, Frame, or MultiPage changes size. (works fine for me in xl97 in that case - changing size) Moving doesn't seem to equate to changing the size. Not sure why it works in XP iwth Office 2003 -- Regards, Tom Ogilvy "Rick Brown" wrote in message om... On my XP system running Office2003 I use the below code to stop anyone from dragging my UserForm thus exposing Excels menus. All works well on the XP machine but does not snap the form back to 0,0 on a machine running Win2000 and Excel97. WHY?????? Private Sub UserForm_Layout() Me.Move 0, 0 End Sub Is there other ways to accomplish this goal. Rick |
All times are GMT +1. The time now is 08:04 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com