| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I lock worksheets so only a couple ranges on each allow inp
I have several worksheets w/ fields that display information and allow user
input in a couple of areas on each sheet. Each as macro buttons the user pushes after his input to update another database worksheet. How do I lock the entire db worksheet and all columns on the other sheets except the ranges user input is allowed. The macros need to be able to update data in the locked areas of any sheet. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Hide/lock worksheets | Excel Worksheet Functions | |||
| how do I lock the first tab of multiple worksheets | Excel Worksheet Functions | |||
| How do I lock some of the worksheets in an excel 07 spreadsheet | Excel Worksheet Functions | |||
| A couple of questiosn on Named Ranges | Excel Discussion (Misc queries) | |||
| How can I lock worksheets while macros can still enter into them? | Excel Discussion (Misc queries) | |||
Threaded Mode
