L LSB Jul 28, 2003 #1 Can anybody tell me how too lock a column, where by i do not want to allow user to update that column.? ..
Can anybody tell me how too lock a column, where by i do not want to allow user to update that column.? ..
A Abdul Salam Jul 28, 2003 #2 Format>Cells>Protection 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 Tools>Protection>Ptotect 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
Format>Cells>Protection 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 Tools>Protection>Ptotect 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
