The files in the outlined area need to be protected except when documents need to be added or deleted, so I have a Lock/Unlock button for protecting the cells in that range.
This code snippet is as close as I have been able to come to allowing .pdf files to be inserted, moved around and deleted from the outlined range (B26:C37) while the sheet is protected. The problem is that there are a couple of show/hide pictures outside of the that range that toggle red (locked) or green (unlocked) based on whether the range is locked from editing or not, and the snippet also unprotects them. I'd like them to stay protected with the rest of the sheet. Is there a way to apply this to just B26:C37?
ActiveSheet.Protect "", DrawingObjects:=False, Contents:=True, Scenarios:=True
Bookmarks