unlocked cell

I built a worksheet that has cells which are unlocked for my agents to enter information and then they can click a button which calculates an amount and some phrasing below. The data that needs to be entered spans across a few different columns and rows. I have the cells which require...

<tbody> <tbody> when toggle between tabs and one of them is an pivot tab, if the selected cell is on the pivot table it will freeze the cell and tab and wont let me move to another cell or tab unless i double click anywhere in the sheet to unfreeze. how can i remove this? </tbody> </tbody>

Hey there. I'm trying to create a macro that unlocks all cells on all worksheets in the active workbook. I've gotten it to work on the active worksheet, but I can't figure out how to make the macro apply to all worksheets. This is what I have so far: Sub UnlockCells() ' ' UnlockCells Macro ' '...

Hi, I've found a quirk of Excel 2007 which I can't seem to overcome: When a cell has: 1) a comment, and 2) data validation as a list, and 3) no "locked" status in the "protection" tab of the formatting window. And when the worksheet containing this cell is protected, and the cell is...