My original spreadsheet had two columns that imported values based on VLookup functions. Both columns were locked for editing and protected to prevent users from changing data in those two columns. This works fine and as intended. I now need to add new columns that can contain one or more values, so I wrote some code to allow multiple entries for cells in the new column. That works too. However, when I protect the sheet, the locked columns work like before, but the multiple selections for the new column stops working. When I unprotect the sheet, everything works but I really need to protect the two original cells. I tried adding subs for unprotect and protect and call them before and after the script, but I get a compile error, Member already exists in an object module from which this object module derives. I am trying to solve this on my own and watched countless videos to no avail. I am hoping someone can point me in the right direction and either tell me what I am doing wrong and why, and what I need to research to resolve. Any help is greatly appreciated.
Original Code - Works fine when the sheet is unprotected.
Same Code using Protect/Unprotect Calls - This gives me the Compile error on Unprotect![]()
Please Login or Register to view this content.
This works based on guidance received.![]()
Please Login or Register to view this content.
![]()
Please Login or Register to view this content.
Bookmarks