How can I lock a number of cells within a worksheet?
 

I have tried to lock a number of cells in a worksheet following the Excel
help tool, but it doesn't work. How could I do it?

Thanks in advance,

IGA

Hi
Highlight the cells that you want to leave open.
Goto TOOLS/OPTIONS/PROTECTION and uncheck the locked box.
Now Goto TOOLS/PROTECTION/PROTECT SHEET.

Just accept the prompt if you don't want to input a password.

HTH
Michael

"IGA" wrote:

I have tried to lock a number of cells in a worksheet following the Excel
help tool, but it doesn't work. How could I do it?

Thanks in advance,

IGA

Michael

Make that FormatCellsProtection and uncheck the "locked" box.

IGA

By default all cells are locked when sheet protection is enabled.

To lock just a few, hit CTRL + A(twice in 2003) to select all cells.

FormatCellsProtection. Uncheck "locked" and OK.

Now select just the cells you want locked and check the "locked" box.

Sheet Protection must be enabled as Michael points out.

Note: ToolsCustomizeCommandsFormat. Scroll down until you find a padlock
icon.

Drag that to your Toolbar and use it to lock and unlock cells before
protecting sheet.


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 14:13:03 -0800, "Michael"
wrote:

Hi
Highlight the cells that you want to leave open.
Goto TOOLS/OPTIONS/PROTECTION and uncheck the locked box.
Now Goto TOOLS/PROTECTION/PROTECT SHEET.

Just accept the prompt if you don't want to input a password.

HTH
Michael

"IGA" wrote:

I have tried to lock a number of cells in a worksheet following the Excel
help tool, but it doesn't work. How could I do it?

Thanks in advance,

IGA

Sorry Gord
See what happens when you haven't had your morning coffee

Michael

"Gord Dibben" wrote:

Michael

Make that FormatCellsProtection and uncheck the "locked" box.

IGA

By default all cells are locked when sheet protection is enabled.

To lock just a few, hit CTRL + A(twice in 2003) to select all cells.

FormatCellsProtection. Uncheck "locked" and OK.

Now select just the cells you want locked and check the "locked" box.

Sheet Protection must be enabled as Michael points out.

Note: ToolsCustomizeCommandsFormat. Scroll down until you find a padlock
icon.

Drag that to your Toolbar and use it to lock and unlock cells before
protecting sheet.


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 14:13:03 -0800, "Michael"
wrote:

Hi
Highlight the cells that you want to leave open.
Goto TOOLS/OPTIONS/PROTECTION and uncheck the locked box.
Now Goto TOOLS/PROTECTION/PROTECT SHEET.

Just accept the prompt if you don't want to input a password.

HTH
Michael

"IGA" wrote:

I have tried to lock a number of cells in a worksheet following the Excel
help tool, but it doesn't work. How could I do it?

Thanks in advance,

IGA

Same for me lotsa times and that's after coffee<g

Gord

On Thu, 24 Feb 2005 16:05:01 -0800, "Michael"
wrote:

Sorry Gord
See what happens when you haven't had your morning coffee

Michael

"Gord Dibben" wrote:

Michael

Make that FormatCellsProtection and uncheck the "locked" box.

IGA

By default all cells are locked when sheet protection is enabled.

To lock just a few, hit CTRL + A(twice in 2003) to select all cells.

FormatCellsProtection. Uncheck "locked" and OK.

Now select just the cells you want locked and check the "locked" box.

Sheet Protection must be enabled as Michael points out.

Note: ToolsCustomizeCommandsFormat. Scroll down until you find a padlock
icon.

Drag that to your Toolbar and use it to lock and unlock cells before
protecting sheet.


Gord Dibben Excel MVP

On Thu, 24 Feb 2005 14:13:03 -0800, "Michael"
wrote:

Hi
Highlight the cells that you want to leave open.
Goto TOOLS/OPTIONS/PROTECTION and uncheck the locked box.
Now Goto TOOLS/PROTECTION/PROTECT SHEET.

Just accept the prompt if you don't want to input a password.

HTH
Michael

"IGA" wrote:

I have tried to lock a number of cells in a worksheet following the Excel
help tool, but it doesn't work. How could I do it?

Thanks in advance,

IGA