prevent user moving form on screen

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.

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

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