I am wanting to lock up certain cells that are not being used in a wroksheet
so that those cells cannot be selected and have info entered in them?

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

It is up to you to decide which are to be locked or unlocked when the sheet is
protected.

Format>Cells>Protection is where you would change the "locked" or "unlocked"
status.

Then Tools>Protect>Protect Sheet.


Gord Dibben MS Excel MVP

On Sat, 19 Apr 2008 17:43:46 -0400, "Buzz Local#30" <(E-Mail Removed)> wrote:

>I am wanting to lock up certain cells that are not being used in a wroksheet
>so that those cells cannot be selected and have info entered in them?