| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lock cells
Can you lock individual cells whereby it takes a different password to unlock
each individually locked cell? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lock cells
ToolsProtectionAllow Users to Edit Ranges.
Each range which can be a single cell can have its own password. Gord Dibben MS Excel MVP On Fri, 2 May 2008 14:54:00 -0700, John R wrote: Can you lock individual cells whereby it takes a different password to unlock each individually locked cell? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lock cells
Hi Gordon,
Jumping in... I have XL2000 - don't seem to have the 'Allow Users to Edit Ranges' in my protection options. Am I missing something, or is that a feature of later versions? Regards - Dave. "Gord Dibben" wrote: ToolsProtectionAllow Users to Edit Ranges. Each range which can be a single cell can have its own password. Gord Dibben MS Excel MVP On Fri, 2 May 2008 14:54:00 -0700, John R wrote: Can you lock individual cells whereby it takes a different password to unlock each individually locked cell? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lock cells
I skipped XL2000 when I went from 97 to 2002 so can't speak to that question but
probably came in with 2002 version along with some other new features for protecting worksheets. Keep eye on this, someone will drop in with an answer. Gord On Fri, 2 May 2008 15:47:01 -0700, Dave wrote: Hi Gordon, Jumping in... I have XL2000 - don't seem to have the 'Allow Users to Edit Ranges' in my protection options. Am I missing something, or is that a feature of later versions? Regards - Dave. "Gord Dibben" wrote: ToolsProtectionAllow Users to Edit Ranges. Each range which can be a single cell can have its own password. Gord Dibben MS Excel MVP On Fri, 2 May 2008 14:54:00 -0700, John R wrote: Can you lock individual cells whereby it takes a different password to unlock each individually locked cell? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lock cells
Added in xl2002.
Dave wrote: Hi Gordon, Jumping in... I have XL2000 - don't seem to have the 'Allow Users to Edit Ranges' in my protection options. Am I missing something, or is that a feature of later versions? Regards - Dave. "Gord Dibben" wrote: ToolsProtectionAllow Users to Edit Ranges. Each range which can be a single cell can have its own password. Gord Dibben MS Excel MVP On Fri, 2 May 2008 14:54:00 -0700, John R wrote: Can you lock individual cells whereby it takes a different password to unlock each individually locked cell? -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
lock cells
Hi Gordon & Dave,
Thanks for the info. Regards - Dave. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| lock used cells | Excel Discussion (Misc queries) | |||
| lock cells | New Users to Excel | |||
| How lock just some cells | New Users to Excel | |||
| How do I lock all cells in a given row together to one another? | Excel Discussion (Misc queries) | |||
| Lock Cells | Excel Discussion (Misc queries) | |||
Linear Mode
