| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I lock a cell in excel file ?
Hi,
I want to lock few cells which carries formulae, so that data entry person do not make any changes. He or she only enters the data. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I lock a cell in excel file ?
the default setting for cells is locked. However, this is not enforced
until the worksheet is protected. Have you unlocked the cells that you want the user to have access to, then protected the sheet? -- Regards, Tom Ogilvy <Raja; "London" <Raja, wrote in message ... Hi, I want to lock few cells which carries formulae, so that data entry person do not make any changes. He or she only enters the data. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how can i lock a sheet in an excel file???? | Excel Discussion (Misc queries) | |||
| open excel file but lock account | Excel Discussion (Misc queries) | |||
| HOW TO LOCK/STOP THE OPENING OF 1 SHEET AMONG 3 IN 1 EXCEL FILE? | Excel Discussion (Misc queries) | |||
| Excel fails to lock file across VPN? | Excel Discussion (Misc queries) | |||
| Importing LDB (Access Lock File) Into Excel | Excel Programming | |||
Linear Mode
