Lock entire Row if Value in Col A = X

Last edited by bakerman2; 10-31-2017 at 07:37 AM. Reason: Slight change to code.

Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.