password protected certain cells in spreadsheet

[Guest]

Hi folks,

can I use password protect some cells and use another password protect some
other cells within the same workbook?? using vba/marco??

Thnaks
VV

 

[Myrna Larson]

If I understand correctly, you can have different passwords for different
worksheets, but not different passwords for different cells on a single sheet.

 

[Dave Peterson]

xl2002 added this level of granularity.

If I understand correctly, you can have different passwords for different
worksheets, but not different passwords for different cells on a single sheet.