View Single Post
 
Old 07-12-2017, 01:11 PM
gebobs gebobs is offline Windows 7 64bit Office 2010 64bit
Expert
 
Join Date: Mar 2014
Location: Atlanta
Posts: 837
gebobs has a spectacular aura aboutgebobs has a spectacular aura about
Default

It's a two step process. By default, all cells are locked. If there are any cells that you would like editable by others, you need to unlock them at Home:Cells:Format:Format Cells. Go to the Protection tab in this dialog and uncheck "Locked". If you do this a lot like I do, you will want to put the Lock Cell toggle button on your Quick Access Toolbar.

Next, you need to protect your sheet at Review:Changes:Protect Sheet. There are several protection options you can enable/disable. You can add a password if you want. If you don't, anyone can turn protection off. I usually don't use a password unless protection is critical. If you forget the password, sayonara worksheet. Again, if you do this a lot, you can add the toggle to the Quick Access Toolbar.
Reply With Quote