Versions Compared

Version Old Version 17 New Version 18
Changes made by

Daniel LaGrow

Daniel LaGrow

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Info

Another good thing to add in forms is a “Clear Form” Button. These buttons will clear the form instantly with one click.

...

Section 8.5: Locking and Protecting

Forms should always be locked and protected. This is done to protect users from changing information by mistake. To lock and protect your form,

  1. Highlight the input cells, right click, and select Format Cells.

    A restaurant complaint form.Image Added

  2. In the dialog box, click the Protection Tab and un-check the Locked Option. Click OK.

    Format Cells Dialog box with the Protection Tab open. The Locked option is unchecked.Image Added

  3. Go to the Review Tab of the ribbon. Select Protect Sheet.

    Review Tab in ExcelImage AddedThe Protect Section in MS Excel. Protect Sheet is all the way to the left.Image Added

  4. In the Protection Sheet Dialog Box, make sure “Select Locked Cells” and “Select Unlocked Cells” are checked. Everything else can be unchecked. Click OK.

    Protect Sheet dialog box with select locked cells and select unlocked cells checked.Image Added

  5. Optional: You can create a password.

  6. Now with your spreadsheet saved, a user will only be able to make changes to the input fields. If they tried to make changes, an alert message will appear.

...