Protecting different ranges with different passwords

A

Ajit

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)
 
F

Frank Kabel

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.
Click to expand...
Business need is that after some processes the original
password protection remain in place and the whole sheet be
protected with another password.
 
D

Dave Peterson

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.
 
Top