Posted 16 January 2012 - 01:21 PM
Hi all, I have an excel sheet that is protected since there are many users. However, from time to time, a few people need to unprotect the sheet to make edits and we are running into a problem when we need to re-protect the sheet. When you protect the sheet, select locked cells and select unlocked cells are checked off by default but we have to remember to scroll down and also check off edit objects. This is causing a problem because sometimes the check off of edit object is forgotten which messes up the page for the rest of the users. Is there a way to set this box up to be checked by default just as the select locked cells and select unlocked cells are? Thanks for any advice!