On the Protection tab, select the Locked check box. To prevent a user from moving, sizing, or deleting a control, right-click the selection, and then click Format Control. Select the control that you want to protect.įor more information, see Select or deselect controls on a worksheet. On the Developer tab, in the Controls group, turn on Design Mode. For more information, see Show the Developer tab. Make sure that the Developer tab is available. If one or more controls is an ActiveX control: You may want to add protection to Form controls and ActiveX controls to prevent users from moving, changing, or deleting controls. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.
0 kommentar(er)
