×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Protecting Cells containing data validation

Protecting Cells containing data validation

Protecting Cells containing data validation

(OP)
Hi All

I have a spreadsheet on which I am collecting monthly submissions on compliance with various company KPI's. We have it set up so that the spreadsheets for each site are contained in different tabs within a single workbook. When the user opens the spreadsheet I want them to be able to select the site they are doing the submission for and the month they are doing. Only the sheet for their selected site will be shown. I would then like only the month that they are working with to be available for editing. The other month columns should be read only so that they cant be changed. This is the bit im struggling with. I know how to lock a cell normally but not sure how to lock a cell containing data validation based on the value chosen in another drop down box (the month)

Can anyone help

RE: Protecting Cells containing data validation

Elsie,

I can't envision the circumstance you are referring to. Can you upload an example of this kind of situation or at least explain it in more detail so we can know how the dv dropdown is/is not working.

Just shooting-from-the-hip, I might use the Worksheet_SelectionChange Event to prevent selection of cells you don't want changed, rather than locking cells. This would entail a means of "remembering" which range was previously selected and returning to that previous range from any forbidden ranges.

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

RE: Protecting Cells containing data validation

Elsie, did you get this worked out?

Skip,

glassesJust traded in my OLD subtlety...
for a NUance!tongue

"The most incomprehensible thing about the universe is that it is comprehensible" A. Einstein

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close