You must turn off worksheet protection when you want to build a form.

Turning off sheet protection enables you to use the form controls on the Developer tab of the Ribbon and allows you to edit worksheet content.

When youre done building the form, you must turn on protection so that people can tab through the input fields.

You unlock cells that you want to designate as input fields, which are the cells that users fill in.

You also unlock the cells that will have the result of a choice made by a user in a form control.

Conversely, when youre ready to test or use your form, you must turn on protection.

The Protect Sheet button has become an Unprotect Sheet button.

Your worksheet is enabled for editing, and the Unprotect button reverts to the Protect Sheet button.

Click the Protection tab in the Format Cells dialog and then deselect the Locked option.

If you installed the MVP Toolbar, you can simply click the LockUnlock Cell toggle button on the toolbar.

On the MVP Toolbar, the Lock Cell button acts as status indicator.

When it appears as a depressed button, the selected cell(s) is (are) locked.

It always indicates the lock state of the current selection.

In the Format Control dialog, click the Protection tab and deselect the Locked option.

Excel Spreadsheet Locked For Editing Professional Presentations And

His business is creating professional presentations and templates, and he manages the PowerPoint sites indezine.com and ppted.com.

James Gordon is a Microsoft MVP for Macintosh, creator of the InsertPicture add-in for Mac PowerPoint, and an Office trainer.

Excel Spreadsheet Locked For Editing Mac