Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA Code - Find & Move | Excel Discussion (Misc queries) | |||
VBA Code - Find & Move | Excel Discussion (Misc queries) | |||
Move/Copy Worksheet -- does not work | Excel Worksheet Functions | |||
How to move files from the code | Excel Programming | |||
UserForm_Layout event - Excel97 | Excel Programming |