Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I lock certain cels i a worksheet
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? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lock worksheet, based on dropdown selection prior worksheet | New Users to Excel | |||
Lock out worksheet | Excel Programming | |||
the use of $ in cels | Charts and Charting in Excel | |||
Autofill cels based on two dates in adjacent cels | Excel Worksheet Functions | |||
Locking cels using a UDF | New Users to Excel |