protect worksheet with multiple passwords

[andyc209]

I have an excel file with three worksheets in it. I can happily protect each sheet with a different password but what i want to be able to do is the following:

a. have a global administrator password for all the sheets - so i assume set the same password to protect the whole sheet
b. have individual passwords that only allow the user to insert rows and change data within restricted columns, i.e. can only edit columns A:Z and cannot manipulate any formulas within that range A:Z

i have excel 2010 if that makes any difference

thanks for any pointers

[andyc209]

anyone? really stuck with this one

[:) Sixthsense :)]

Let the user to unprotect/protect the sheet by entering the password in form text box.

I am just giving the below code as a sample (untested) to let you know how to do it.

Please Login or Register  to view this content.

Here "Abc", "Def", "Xyz", "Ijk" are the passwords given to different users but the base password will be OriginalPassword