View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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