How to drag some objects and forms in VBA / Excel and prevent the dragging of others?

Navigation
0

I'm having trouble trying to control "dragging forms" and "dragging objects" in VBA / Excel.

For example: I have the main form that I do not want to be moved, a second form is called from the main and can be moved, and I have certain objects that I need to move in it (images, for example), and then I want to return to the main form.

How do I do it?

    
asked by anonymous 08.12.2015 / 14:11

1 answer

1

To prohibit dragging, paste in your form code

  

Private Sub UserForm_Layout () Me.Move 350, 282 End Sub

    
09.12.2015 / 12:15
How to extract data from plain non-standard texts? How to bring the selected ball forward (z-index higher) in Highcharts?