A
A
Alexander Shilov2019-04-23 16:06:43
excel
Alexander Shilov, 2019-04-23 16:06:43

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?

Controls
5cbf0de11065b927939096.png

Answer the question

In order to leave comments, you need to log in

1 answer(s)
J
John Smith, 2019-04-23
@tabbols95

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 question

Ask a Question

731 491 924 answers to any question