Re your question in post #17:
the 'clearing' of the row is performed by the code below
the most important step is
which sets a range of cells to be cleared by combining ('UNION') two separate ranges.
The first range consists of
Meaning the cells on the row specified by the user, from column A, and 5 columns in length - thus effectively from column A to E
The second range being joined is depicted by the below statement
a similar trick but now starting in column G and only 2 columns in length - thus effectively from column G to H
when you combine the two you have all the cells from A to H on the row selected by the user, with the exception of column F which is now your protected column. All subsequent actions (highlighting, clearing and removing the highlight) are performed against this range object (' rngClear').
If you are going to change the protected column, the only thing you need to change is the following statement using the explanation above
I hope I was able to explain this sufficiently
Bookmarks