| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Protecting different ranges with different passwords
I have an excel sheet with some of the ranges protected. Business need is that after some processes the original password protection remain in place and the whole sheet be protected with another password.
Could someone help me how could this be possible ... (without coding) -- Ajit |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting different ranges with different passwords
Hi
Excel only supports one password/protection level per worksheet. So without coding no chance (and coding can be easily circumvented by not enabling macros) -----Original Message----- I have an excel sheet with some of the ranges protected. Business need is that after some processes the original password protection remain in place and the whole sheet be protected with another password. Could someone help me how could this be possible ... (without coding) -- Ajit . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Protecting different ranges with different passwords
xl2002+ does support this range by range protection.
But the only ways I know to password protect the worksheet is tools|protection or via code. Ajit wrote: I have an excel sheet with some of the ranges protected. Business need is that after some processes the original password protection remain in place and the whole sheet be protected with another password. Could someone help me how could this be possible ... (without coding) -- Ajit -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| protecting without passwords? | Excel Discussion (Misc queries) | |||
| Protecting different cells in Excel with different passwords | Excel Discussion (Misc queries) | |||
| Can I create Multiple passwords to edit multiple ranges? | Excel Discussion (Misc queries) | |||
| Macro for unprotecting/protecting worksheets WITH passwords | Excel Programming | |||
| Different passwords to separate ranges in excel 2000 | Excel Programming | |||
Linear Mode
