conditionally lock cells?

G

GoBobbyGo

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?
 
M

murob2

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Fill cells based on the other 3 cells unique combination the value on the target cell 0
summarizing data from various workbooks 4
Formula fill series? 1
Looking to added up based on a character from cell range 1
Need to have data in one column 1
Lock cells conditionally formatted in 2007 1
If Condition 0
Lock location of sheet within a spreadsheet 4

Top