| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
cells protection
Hello,
is it possible to protect different cells group of a sheet with different password so that different users can have possibility to modify only some cells and not others? Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cells protection
I believe there is only one password per sheet. You might be able to
implement something in code, but such protection is easily overcome (either code or protecting a sheet with a password). You might make a separate workbook for each group of users and develop a method to consolidate the data from each in a single separate workbook. -- Regards, Tom Ogilvy "gulp!" wrote in message ... Hello, is it possible to protect different cells group of a sheet with different password so that different users can have possibility to modify only some cells and not others? Thanks |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cells protection
|
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cells protection
It added the ability to assign separate passwords to each range.
Wow! -- Regards, Tom Ogilvy Dave Peterson wrote in message ... xl2002 added that feature. Tools|Protection|Allow Users to Edit Ranges "gulp!" wrote: Hello, is it possible to protect different cells group of a sheet with different password so that different users can have possibility to modify only some cells and not others? Thanks -- Dave Peterson |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cells protection
And colored worksheet tabs, too!
Tom Ogilvy wrote: It added the ability to assign separate passwords to each range. Wow! -- Regards, Tom Ogilvy Dave Peterson wrote in message ... xl2002 added that feature. Tools|Protection|Allow Users to Edit Ranges "gulp!" wrote: Hello, is it possible to protect different cells group of a sheet with different password so that different users can have possibility to modify only some cells and not others? Thanks -- Dave Peterson -- Dave Peterson |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cells protection
I knew about the sheet tabs colors and the ability to work with protection
applied to specific users. But I didn't realize you could assign separate passwords to each range. Guess I will have to install it on the main computer or walk downstairs and play with it. -- Regards, Tom Ogilvy Dave Peterson wrote in message ... And colored worksheet tabs, too! Tom Ogilvy wrote: It added the ability to assign separate passwords to each range. Wow! -- Regards, Tom Ogilvy Dave Peterson wrote in message ... xl2002 added that feature. Tools|Protection|Allow Users to Edit Ranges "gulp!" wrote: Hello, is it possible to protect different cells group of a sheet with different password so that different users can have possibility to modify only some cells and not others? Thanks -- Dave Peterson -- Dave Peterson |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cells protection
This time, _I_ was going for the humorous effect.
Tom Ogilvy wrote: I knew about the sheet tabs colors and the ability to work with protection applied to specific users. But I didn't realize you could assign separate passwords to each range. Guess I will have to install it on the main computer or walk downstairs and play with it. -- Regards, Tom Ogilvy Dave Peterson wrote in message ... And colored worksheet tabs, too! Tom Ogilvy wrote: It added the ability to assign separate passwords to each range. Wow! -- Regards, Tom Ogilvy Dave Peterson wrote in message ... xl2002 added that feature. Tools|Protection|Allow Users to Edit Ranges "gulp!" wrote: Hello, is it possible to protect different cells group of a sheet with different password so that different users can have possibility to modify only some cells and not others? Thanks -- Dave Peterson -- Dave Peterson -- Dave Peterson |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cells protection
There are instructions in the following MSKB article:
HOW TO: How to Apply Different Passwords or Permissions to Separate Ranges in Worksheets in Excel 2002 http://support.microsoft.com/?kbid=289270 Dave Peterson wrote: xl2002 added that feature. Tools|Protection|Allow Users to Edit Ranges "gulp!" wrote: is it possible to protect different cells group of a sheet with different password so that different users can have possibility to modify only some cells and not others? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cells protection
Thanks Debra.
Done any testing/exploration on this with JE McGimpsey's/Norman Harker's password breaking code? -- Regards, Tom Ogilvy Debra Dalgleish wrote in message ... There are instructions in the following MSKB article: HOW TO: How to Apply Different Passwords or Permissions to Separate Ranges in Worksheets in Excel 2002 http://support.microsoft.com/?kbid=289270 Dave Peterson wrote: xl2002 added that feature. Tools|Protection|Allow Users to Edit Ranges "gulp!" wrote: is it possible to protect different cells group of a sheet with different password so that different users can have possibility to modify only some cells and not others? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cells protection
Their code removes the sheet protection, which unlocks the ranges. Once
the sheet is unprotected, you can delete or modify the ranges, or set new passwords. There's some programming information he Using the Protection Object to Protect Your Worksheets http://msdn.microsoft.com/library/de...webProtSht.asp Tom Ogilvy wrote: Thanks Debra. Done any testing/exploration on this with JE McGimpsey's/Norman Harker's password breaking code? -- Regards, Tom Ogilvy Debra Dalgleish wrote in message ... There are instructions in the following MSKB article: HOW TO: How to Apply Different Passwords or Permissions to Separate Ranges in Worksheets in Excel 2002 http://support.microsoft.com/?kbid=289270 Dave Peterson wrote: xl2002 added that feature. Tools|Protection|Allow Users to Edit Ranges "gulp!" wrote: is it possible to protect different cells group of a sheet with different password so that different users can have possibility to modify only some cells and not others? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#11
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
cells protection
Thanks again for the references.
Didn't mean to put you to any trouble. Just wondered if you had looked into it. Seems no additional strength if the removal of protection removes the range protection as well - but it makes sense. -- Regards, Tom Ogilvy Debra Dalgleish wrote in message ... Their code removes the sheet protection, which unlocks the ranges. Once the sheet is unprotected, you can delete or modify the ranges, or set new passwords. There's some programming information he Using the Protection Object to Protect Your Worksheets http://msdn.microsoft.com/library/de...us/dnexcl2k2/h tml/odc_xlwebProtSht.asp Tom Ogilvy wrote: Thanks Debra. Done any testing/exploration on this with JE McGimpsey's/Norman Harker's password breaking code? -- Regards, Tom Ogilvy Debra Dalgleish wrote in message ... There are instructions in the following MSKB article: HOW TO: How to Apply Different Passwords or Permissions to Separate Ranges in Worksheets in Excel 2002 http://support.microsoft.com/?kbid=289270 Dave Peterson wrote: xl2002 added that feature. Tools|Protection|Allow Users to Edit Ranges "gulp!" wrote: is it possible to protect different cells group of a sheet with different password so that different users can have possibility to modify only some cells and not others? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cells protection | New Users to Excel | |||
| About protection of Cells | New Users to Excel | |||
| Protection on particular cells | Excel Discussion (Misc queries) | |||
| Cells Protection | Excel Discussion (Misc queries) | |||
| auto protection of cells | Excel Worksheet Functions | |||
Hybrid Mode
