Hi,

I have an excel document that allows the user to create text boxes via
a user form. The coordinates for the textbox are determined when it is
created based on the last row and column populated in excel. How do I
prevent the user from moving the boxes? I have attempted to use the
anchor property but it is not working. I also attempted to lock the
boxes, however there is an on-click event that cannot be used if I lock
the boxes and protect the sheet. The only other thing is that if a
user adds a column \, I still want to boxes to adjust accordingly, as
they do now. Any help would be greatly appreciated!!

Thanks again!!