Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditionally lock cells?
Is there a way to conditionally lock cells?
For example, can I prevent someone from filling in B3, C3, etc unless they put a valid employee name in A3? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
conditionally lock cells?
Absolutely - You are going to use Visual Basic for Applications. This comes
with Microsoft Office, but is not necessarily installed, so keep in mind you might need the installation disk to install VBA or programming support for excel. Let me get back to you within a half hour or so, and I'll have the code written for you and I'll walk you through using VBA in Excel to get it working for you. In the mean time, let me know if you have any other questions. ~Rob "GoBobbyGo" wrote in message ... Is there a way to conditionally lock cells? For example, can I prevent someone from filling in B3, C3, etc unless they put a valid employee name in A3? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an add-in that will lock the cells like later versions of Excel? | New Users to Excel | |||
how do i protect cells in a shared worksheet | Excel Discussion (Misc queries) | |||
Can I lock a set of cells in a worksheet? | Excel Discussion (Misc queries) | |||
Can I use the grouping and lock and protect cells | Excel Discussion (Misc queries) | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions |