You can protect the content of cells from being changed and/or hide the formulas of cells from being viewed.
Conditions for protecting cells
Conditions for hiding text/formula in the Formula bar
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
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!
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?