preventing userform movement

Is it possible to prevent a user from being able to move a userform around the screen area (clicking and holding caption bar)? I am captureing a image and using Pixels coordinates on the capture and need the userform to stay in the center of the screen or the image will not be catptured.

The StartupPosition is center of screen, tried

Please Login or Register  to view this content.

to force it back to center screen if moved but get Invalid Quilifier for startupposition.

cheap and cheerful code

Please Login or Register  to view this content.

Hi Andy,

in what module do I have to place your code below to reposition a moved user form. I tried it out with userform1 in worksheet 1 but it didn't work (I was able to move the form and it did not move back into the original position). My understanding is that the script works on any userform in any sheet that i touched or ?

PS. It seems that my VBA 2007 does not know the commands Me.Left, me.top, me.move but maybe I placed it in the wrong module?

Thanks for you help !

Thomas


**************

Please Login or Register  to view this content.

**************

kle,

Unfortunately you need to post your question in a new thread, it's against the forum rules to post a question in the thread of another user. If you create your own thread, any advice will be tailored to your situation so you should include a description of what you've done and are trying to do. Also, if you feel that this thread is particularly relevant to what you are trying to do, you can surely include a link to it in your new thread.

Also,

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.