Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protecting certain cells in Ecxel 2007
I've created a spreadsheet for my work to calculate the number of patrons and
sales. I would like to protect only the cells that have formulas in them, so that the formulas cannot be changed or erased. When I highlight a cell that I want to protect, I have tried going to "format cells" and then clicking on "protect"; but a pop up window appears and tells me that I must turn "sheet protection" on first. However, when I do that, the entire sheet is locked and I cannot enter in the daily guest counts. Anybody have a solution? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protecting certain cells in Ecxel 2007
Select the cells you wish users to access. Right-click with mouse and
select Format Cells. In the dialog box select Protection Page and remove the tick from the locked option. Click Ok. Now invoke sheet protection from Ribbon/Menu (2007/2003) and in the dialog box in the section "Allow all users...", remove the tick against "Select locked cells". Leave the next one. Add a password if you wish. That's it. The users can only select and enter data in the unlocked ones. It might be worth giving them a different background colour as well. I am assuming you have either 2007 or 2003. Paul "Energizer Bunny" wrote in message ... I've created a spreadsheet for my work to calculate the number of patrons and sales. I would like to protect only the cells that have formulas in them, so that the formulas cannot be changed or erased. When I highlight a cell that I want to protect, I have tried going to "format cells" and then clicking on "protect"; but a pop up window appears and tells me that I must turn "sheet protection" on first. However, when I do that, the entire sheet is locked and I cannot enter in the daily guest counts. Anybody have a solution? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
protecting certain cells in Ecxel 2007
Thanks. I'll give it a shot. Yes, I do use Excel 2007.
"Paul" wrote: Select the cells you wish users to access. Right-click with mouse and select Format Cells. In the dialog box select Protection Page and remove the tick from the locked option. Click Ok. Now invoke sheet protection from Ribbon/Menu (2007/2003) and in the dialog box in the section "Allow all users...", remove the tick against "Select locked cells". Leave the next one. Add a password if you wish. That's it. The users can only select and enter data in the unlocked ones. It might be worth giving them a different background colour as well. I am assuming you have either 2007 or 2003. Paul "Energizer Bunny" wrote in message ... I've created a spreadsheet for my work to calculate the number of patrons and sales. I would like to protect only the cells that have formulas in them, so that the formulas cannot be changed or erased. When I highlight a cell that I want to protect, I have tried going to "format cells" and then clicking on "protect"; but a pop up window appears and tells me that I must turn "sheet protection" on first. However, when I do that, the entire sheet is locked and I cannot enter in the daily guest counts. Anybody have a solution? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Getting Warning when I try to open ecxel in 2007. | Excel Discussion (Misc queries) | |||
protecting several parts of a worksheet in Excel 2007 | Excel Discussion (Misc queries) | |||
Excel search in cell - ecxel 2007 | Excel Worksheet Functions | |||
Protecting a 2007 Workbook continued... Bob Phillips you out there | Excel Discussion (Misc queries) | |||
Protecting a 2007 Workbook continued... Bob Phillips you out there | Excel Discussion (Misc queries) |