» Protecting Sheets / Cells in Microsoft Excel
CATEGORY - Excel Security - Protection
VERSION - All Microsoft Excel Versions
You can protect the content of cells from being changed and/or hide the formulas of cells from being viewed.
Conditions for protecting cells
- The cell must be locked (in the Format Cells dialog box, Protection tab).
- The sheet must be protected.
- The cell must be hidden (in the Format Cells dialog box, Protection tab).
- The sheet must be protected.
Book Store:
Protection of Scroll-down Lists
Ezra W Posted on: 31-12-1969
I created a Data Validation scroll-down list in MS Excel 2002, and locked it and then protected the sheet, and I can select fine from the list. But when I open the file in 2002 version and try to select from the scroll-down list, a pop-up appears which says the cell is protected and is unchangeable. How can I get a scroll-down list to work in 2002 even while the ability to actually type into that cell is restricted?Protecting Sheets in a Workbook
Christina Posted on: 31-12-1969
I created a workbook with different sheets within it. Each sheet is for a different department. Is there a way that I can e-mail just the sheet and not the whole workbook?? Or is there a way to have a different password to view each tab?? Either of these would work. I need help fast!Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
