I got the code below from one of Dave Peterson's posts -- to set cell
protection based on a value input. Works fine.

For the initial pass, however, the values in the spreadsheet (col b) are
already populated and I need to modify the code for a one-time use to set the
protection of column A using the existing values in column B instead of the
macro running when the worksheet is changed. I don't know how to do this. Any
help appreciated.

--
cm