Locked Cells Not Working

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.

I can't, the embedded formulas are something I cannot share. I saw a couple of threads similar to mine posted in the last 5 years(never resolved that I know of), so I think my problem is not unique, although rare. I may move the "sacred" formulas away from unlocked cells that are contributing to the problem, or move them to another tab and reference back. Thanks.

Excel 2010. I moved the formulas(5 batches of 6 columns each) to the far right of my spreadsheet, so that there are not unlocked cells on boths sides of the locked cells, and now everything is protected. This wasn't my preferred way to handle the problem, but got it resolved. I've used locked cells and passwords for years now in a few versions of Excel, and this is a first for me as well. Thanks for your time.

Does Microsoft read content here, or what's the best way to fill them in on this "bug"? Thanks.

One more question related to locking cells. Is there a way to stop someone from using developer tools to unlock the cells? Thanks.