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!
Page 1 of 1
Excel and setting edit object to be checked by default
#2
Posted 28 January 2012 - 12:29 AM
The few complex ways you can give your members to make changes are too error-prone to bother with.
Best solution: You need a trusted monitor to receive all inputs and make changes.
Best solution: You need a trusted monitor to receive all inputs and make changes.
Share this topic:
Page 1 of 1

Help

Back to top








