Prevent user moving the userform with mouse

  • Thread starter Thread starter AP
  • Start date Start date
A

AP

I have a userform which is gradually moved downwards by a macro.

I would like to prevent the user from manually shifting the userform (by
dragging the title bar with the mouse). At the same time, I would like to
allow the buttons on the userform to be interactive with the user.

"UserForm1.Enabled = False" prevents the user from shifting the userform ...
but also disables all buttons on the userform!

Any help would be greatly appreciated.
 
Why not remove the form's caption altogether, plenty of examples in this ng.
You might need add a close button, if you don't already have one, to
simulate the little x.

Regards,
Peter T
 
Thanks for the excellent suggestion ... I found the code in "Colo's
Junk Room".

Cheers
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Call random UserForm from list 10
Hiding a "Userform" instead of closing it??? 3
can't move UserForm with the mouse 2
Referencing a UserForm in a Module 2
Userform - Title bar formatting options and other attributes 2
Position Userform In Cells Portion of Excel Only 1
Userform, Calender, Problems with Todays Date 4
When this happens, do that, then do the next thing 7

Back
Top