Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking column
Can anybody tell me how too lock a column, where by i do
not want to allow user to update that column.? .. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locking column
FormatCellsProtection Check Locked
and uncheck locked for all cells you want to allow the user to change This will work only if the sheet is protected ToolsProtectionPtotect Sheet. where you have several option depending up on your version of Excel By Code: Sub LockCells Range ("A1:B10").Locked = True ActiveSheet.Protect Password:= "Password" End Sub Abdul Salam -----Original Message----- Can anybody tell me how too lock a column, where by i do not want to allow user to update that column.? .. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locking column widths | Excel Discussion (Misc queries) | |||
Locking a Column | Excel Discussion (Misc queries) | |||
Locking column names | Excel Discussion (Misc queries) | |||
Locking column entries to an adjacent linked column | Excel Discussion (Misc queries) | |||
Column widths - locking down | Excel Discussion (Misc queries) |