prevent user moving form on screen

[memphis]

Hi everyone,

I'm wondering if it is possible to prevent the user from moving form on screen.
How can it be done without using the UserForm_Layout event which flicks the screen...
Many thanks.

[royUK]

Why do you want to prevent the userform being moved?

[Leith Ross]

Hello Memphis,

It requires using API calls. Here is the macro code. Load this into a Standard VBA module. Add the command LockPosition to the UserForm_Activate code procedure.

Please Login or Register  to view this content.

Adding the Macro
1. Copy the macro above pressing the keys CTRL+C
2. Open your workbook
3. Right Click on any Sheet's tab
4. Left Click on View Code in the pop up menu
5. Press the keys ALT+I to activate the Insert menu
6. Press M to insert a Standard Module
7. Paste the code by pressing the keys CTRL+V
8. Make any custom changes you need to the macro
9. Save the Macro by pressing the keys CTRL+S

Sincerely,
Leith Ross

[memphis]

Thanks Leith Ross, it worked fine!!!!
Thank you royUK for your interest too...
Keep working.