View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Lock Position of Controls on a UserForm

I move controls accidentally all the time. While I don't think there is a
way to lock them down a quick Ctrl-z rights them if you notice it in time.

--
Jim
"RyanH" wrote in message
...
| Is there a way to lock the position of controls on a Userform? I access
the
| controls events by double clicking them and sometimes I accidentally move
| them in the process. Just want to avoid this if possible.
| --
| Cheers,
| Ryan