Password protect 2 columns
 

Help,

I need to password protect just two columns. As there are several people
who have access to this spreadsheet.

I need help ASAP!!!!

Bam

Password protect 2 columns
 

Bam

By default all cells on a sheet are locked when the sheet is protected.

CTRL + a(twice in 2003) to select all cells.

FormatCellsProtection. Uncheck "locked" and OK

Now select the sections/rows/cells to protect and FormatCellsProtection.
Check "locked" and OK

ToolsProtectionProtect Sheet

The section/row locking does not work if you don't protect the sheet.


Gord Dibben MS Excel MVP


On Mon, 21 Aug 2006 10:54:02 -0700, Bam wrote:

Help,

I need to password protect just two columns. As there are several people
who have access to this spreadsheet.

I need help ASAP!!!!

Bam

Gord Dibben MS Excel MVP