Thread: How do I lock certain cels i a worksheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How do I lock certain cels i a worksheet
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.

FormatCellsProtection is where you would change the "locked" or "unlocked"
status.

Then ToolsProtectProtect Sheet.


Gord Dibben MS Excel MVP

On Sat, 19 Apr 2008 17:43:46 -0400, "Buzz Local#30" 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?

Reply With QuoteReply With Quote