Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking all but a few cells on a worksheet | Excel Worksheet Functions | |||
Locking fill colors into rows | Setting up and Configuration of Excel | |||
Locking Info only which came from another worksheet | Excel Discussion (Misc queries) | |||
Locking Part of a Worksheet/Tab | Excel Discussion (Misc queries) | |||
Locking a Worksheet | Excel Worksheet Functions |