Answer the question
In order to leave comments, you need to log in
How to fix controls on an excel form?
Can you please tell me how to fix the elements on the form so that no one else can change their size and location?
Answer the question
In order to leave comments, you need to log in
All controls have a protection item in their properties, it is enabled by default. Same as for cells.
If you protect the sheet, then the element cannot be changed.
The sheet is protected through the File menu:
It is important not to forget to remove protection from all cells that the user should be able to change.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question