Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
read only and write only
l would like to protect my work from other user not all but for the certain
column.for example ; column A 1,A2 ,A3 ,B1 B2,B3 ,C1,C2.C3 and D1.D2 D3 are for write only.{ Column A23, A24,A25 ,B23,B24,B25 ,C23.C24,C25 and D23,D24,D25 ,all the data here are copy from above like A23 is data from Al , so is it any way that the other user can,t change any data here} thank you |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
read only and write only
Select the cells you want your users to be able to alter (CTRL + Clck if they
are not adjacent) and then:- Format|cells|protection and remove the locked checkmark. then Tools|Protection|protect sheet. User are now prevented from changing all cells except the ones you unlocked. Mike "zilah" wrote: l would like to protect my work from other user not all but for the certain column.for example ; column A 1,A2 ,A3 ,B1 B2,B3 ,C1,C2.C3 and D1.D2 D3 are for write only.{ Column A23, A24,A25 ,B23,B24,B25 ,C23.C24,C25 and D23,D24,D25 ,all the data here are copy from above like A23 is data from Al , so is it any way that the other user can,t change any data here} thank you |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
read only and write only
By default, all cells are protected when sheet protection is enabled.
Hit CTRL + a(twice in 2003) to select all cells. FormatCellsProtection. Uncheck "locked" and OK out. Select the cells you want protected and FormatCellsProtection Check "locked". ToolsProtectionProtect Sheet. Note the options when protecting. Supply a password and OK. Excel's internal security is weak but this will prevent overwriting by accident. Gord Dibben MS Excel MVP On Sat, 7 Jul 2007 20:52:04 -0700, zilah wrote: l would like to protect my work from other user not all but for the certain column.for example ; column A 1,A2 ,A3 ,B1 B2,B3 ,C1,C2.C3 and D1.D2 D3 are for write only.{ Column A23, A24,A25 ,B23,B24,B25 ,C23.C24,C25 and D23,D24,D25 ,all the data here are copy from above like A23 is data from Al , so is it any way that the other user can,t change any data here} thank you |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Read/Write Alert | Excel Discussion (Misc queries) | |||
I have a read only xl file, I need it to be read and write | Excel Discussion (Misc queries) | |||
Read-write/Read-only | Excel Discussion (Misc queries) | |||
read only file-need to write | Excel Discussion (Misc queries) | |||
How can a file be converted from Read-Only to Read/Write | Excel Discussion (Misc queries) |