FYI: When the Administrator has the entire file unprotected, the code runs flawlessly. The method of unprotecting the whole workbook and re-protecting is not a viable option given all the actions the code must go through. Even though I have columns ("L:N") that I want to Remove Duplicates on Un-Locked, the code will not remove duplicates. I have a worksheet labeled "DATA1" and in this example the entire workbook has been protected for the users to use only certain cells.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |