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
|