Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you set certain cells as read only?
I want to set a group of cells that calculate values...and I want them to be
readonly. Is this possible? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can you set certain cells as read only?
If by "readonly" you mean that they cannot be changed by the user, you need
to lock the cells and then protect the workbook. By default, all cells are locked, so when you protect the sheet, none of the cells can be changed. First, use CTRL+a to select all the cells (or click the square to the left of the "A" column heading, above the "1" row heading). Go to the Format menu, choose Cells, the Protection tab, and UNCHECK the Locked property. That will make all cells editable even when the workbook is protected. Now select the cells you want to lock. Go back and CHECK the Locked property. Finally, protect the worksheet (Tools menu, Protection, Protect Sheet). Use a password if desired. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "gap1549" wrote in message ... I want to set a group of cells that calculate values...and I want them to be readonly. Is this possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help: Sorting 2 columns according to matching cells, and fishing for duplicates | Excel Discussion (Misc queries) | |||
i need a macro to read blank cells | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Read list of cells; conditional | Excel Discussion (Misc queries) | |||
Show cells have been read - linked | Excel Discussion (Misc queries) |