ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   UserForm_Layout code Me.Move 0, 0 don't work (https://www.excelbanter.com/excel-programming/310439-userform_layout-code-me-move-0-0-dont-work.html)

Rick Brown

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

Tom Ogilvy

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