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.
Hi Closet Guru,
try this one:
Don't forget to adjust the values in the first section to "your" values.
Please Login or Register to view this content.
Let me know if this is what you need.
Theo
Remember To Do the Following....
1. Upload sample files
2. Thank those who have helped you by clicking the Star below the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Thank you, that worked great. And I appreciate your notes explaining each portion of the macro.
Was wondering if there is a way to search by the header, rather than entering the column #, as the column # may change.
Hi ClosetGuru,
sure, just use the macro below (don't forget to adjust the correct Column Header Names):
Let me know if it works now, and don't forget to mark the thread as "Solved" if it does.Please Login or Register to view this content.
Have a happy Easter
Theo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks