Protecting the Worksheet

Protecting the worksheet is the final step prior to testing the form and finishing the project.


Excel 2003: ALT+T (Tools menu), P (Protection submenu), Protect Worksheet (or Workbook, if desired) Excel 2007: ALT+R (Review tab), PS (Protect Sheet)

Picture of the Protect Sheet dialog box in Excel.

Picture of the Protect Sheet dialog box in Excel


  1. A Protect Sheet dialog box appears with focus in the password field. Type in a password if you want to prevent others from changing the form.
  2. Press ENTER and you are prompted to type the password again.
  3. When finished, press ENTER a final time and the Protect Sheet dialog box closes.

Prior page

Next page