Locking a worksheet, but sill fill in informaiton
 

I just completed a worksheet I use as an application. It has drop down lists
and text boxes for information to be placed by clients.

How do I lock the worksheet so the drop down lists and text boxes remain
unlocked so client can use them, and yet lock the worksheet so the questions
and formulas are not affected.

Locking a worksheet, but sill fill in informaiton
 

All you have to do is unlock the cells that can be changed (and any
target cells for your drop downs) before protecting the sheet. It's
Format/Cells/Protection in pre 07, and click the box at the bottom-
right of the Font section of the Home ribbon, and click the Protection
tab in 07.

On Sep 21, 9:54*am, Munchkin
wrote:
I just completed a worksheet I use as an application. *It has drop down lists
and text boxes for information to be placed by clients. *

How do I lock the worksheet so the drop down lists and text boxes remain
unlocked so client can use them, and yet lock the worksheet so the questions
and formulas are not affected.