macro to lock cell by column header based on value in another cell by column header
I have a sales report containing active customers from the database and prospective customers added by the salespeople.
I want to protect the active customers' names. So, I need a macro that:
If cell in the ""Status"" column does not contain the word ""New Prospect"" (there may be other words in this cell), then protect the cell in the ""Customer Name"" column.
Naturally, it needs to search all rows. The number of rows will vary per report. "
Recent comments
6 years 4 weeks ago
6 years 42 weeks ago
7 years 2 weeks ago
7 years 4 weeks ago
7 years 6 weeks ago
7 years 11 weeks ago
7 years 19 weeks ago
7 years 20 weeks ago
7 years 20 weeks ago
7 years 20 weeks ago