locked sheet

Hello, Hopefully somebody can help me with the following issue. And taking in account that I found a huge amount of solutions already at MrExcel, my expectations are high ;-) I have the following situation: A password protected worksheet with a specific cell (for example B2) that is unlocked...

Hello World, I have an excel workbook with the sheets locked for editing to share with a large number of people. My excel cells have more text than is visible and you have to double click the cell to read it all. With the sheet locked however you cannot double click to see all text. Is there...

Hi, I've searched around the forum and couldn't quite find a solution that would match my issue. Sorry if I end up re-asking a question though. I've made a few pull down menus, hid the sheet with the actual data, leaving only the pull down menus available, and locked the sheets to provide...

Hello everyone, I have a problem in Excel 2007, I need certain sheets of a workbook to be locked, but when I lock them the tables inside of the sheet lose the capability to expand/keep formatting when adding new data to them. I have seen other similar posts on the forum but no replies on them...