I have a 17MB spreadsheet that I want to lock down parts of. All of my tabs have various cells locked and password protected, but one tab's locked cells are not working correctly. After password protected, the locked cells cannot be clicked on, but you can highlight unlocked cells on either side of the locked cells, and drag the mouse over the locked cells to unlocked cells on the other side, and whala, can now copy the locked cells. You can't do this on my other tabs, just the one tab is giving me problems. I have the check box to allow selecting unlocked cells only. Please help. Thanks.
Bookmarks