| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I protect a column on a worksheet
on my worksheet, which anyone can use, how do I deny everyone from entering
data on 3 entire columns? these columns contain formulas that deal with the data entered in the other columns. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do I protect a column on a worksheet
1. unprotect both the workbook and worksheet
2. unlock all cells 3. select the 3 columns 4. lock the cells 5. protect the worksheet -- Gary''s Student - gsnu200795 "Sanjo" wrote: on my worksheet, which anyone can use, how do I deny everyone from entering data on 3 entire columns? these columns contain formulas that deal with the data entered in the other columns. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| protect worksheet but allow copy column | Excel Worksheet Functions | |||
| How can i protect worksheet until a value is placed in a certain c | Excel Discussion (Misc queries) | |||
| worksheet protect | Excel Worksheet Functions | |||
| hide a column in a worksheet and password protect | Excel Discussion (Misc queries) | |||
| How to protect a worksheet from being copied to another worksheet | Excel Discussion (Misc queries) | |||
Linear Mode
