View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default 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