password protected certain cells in spreadsheet

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

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

On Tue, 8 Feb 2005 18:23:03 -0800, "vv" <[email protected]> wrote:

>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

xl2002 added this level of granularity.

Myrna Larson wrote:
>
> If I understand correctly, you can have different passwords for different
> worksheets, but not different passwords for different cells on a single sheet.
>
> On Tue, 8 Feb 2005 18:23:03 -0800, "vv" <[email protected]> wrote:
>
> >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

--

Dave Peterson