bradyboyy88
Well-known Member
- Joined
- Feb 25, 2015
- Messages
- 562
Currently I have a button that when clicked it opens opens the userform in the center of the screen regardless of dual monitors or not. Now I want to keep it so that the userform is not movable.
The code to center is shown below:
The code to center is shown below:
Code:
Sub StartNewUserform()
' Displays on top of semi-transparent UserForm
With Userform1
.StartUpPosition = 0
.Left = Application.Left + (0.5 * Application.Width) - (0.5 * .Width)
.Top = Application.Top + (0.5 * Application.Height) - (0.5 * .Height)
.Show
End With
Unload Me
End Sub
[code]
So what property would allow me to make sure its not movable and even better is there also a way to remove the window frame from the userform that has the caption and x button?
Thanks