UserForm_Layout code Me.Move 0, 0 don't work

  • Thread starter Thread starter Rick Brown
  • Start date Start date
R

Rick Brown

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Code to Accept only a 0 or this... 2
Make all variable values in a Array equal to 0 8
ComboBox.Enable giving error on ActiveWorkbook.RefreshAll 10
Spin button to scroll up&down a database with a userform 7
Values don't behave when converting text to values in userform 2
Named Range maker code 9
Help! Combine Macros 2
Snag in invoice generator. How to change the "series" 5

Back
Top