Freeze Userform

[kle3962]

Hi All,

I'll have to freeze a user form position within an excel sheet ("sheet 1", "Userform1")

Does somebody know how to prevent the user from moving the form.

PS. I am a beginner and need to know in what module the code needs to be placed in order to work.

Thanks for you help !

[:) Sixthsense :)]

Check the below link for details:-

http://www.cpearson.com/excel/FormPosition.htm

[john55]

or use the code provided by Andy
http://www.excelforum.com/excel-prog...-movement.html
in vb editor just dbl click on yr userform, view code, copy/paste the above code and it'll work!

[kle3962]

Thanks Guys,

I followed the detailed instruction from: http://excelvbatipsforbeginners.blog...-userform.html. It's understandable and works.

Best, Thomas