please let me know how can i set a range of column to lock

please let me know how can i set a range of column to lock

this code locking whole sheet before entering the words

Please Login or Register  to view this content.

this code locks the whole sheet cells

i am trying make fixed columns to be locked

please let me know

Hi baig123,
try first follow this code

Please Login or Register  to view this content.

and then this one

Please Login or Register  to view this content.

hey i am getting the Run time error '1004':

unable to set the locked property of the range class

ActiveSheet.Cells.Locked = False ------------------>In this line

my sheet is empty after entry of data it should automatically lock the range of column which i have been given in code

Please Login or Register  to view this content.

sorry

iam getting the same output

my whole sheet is getting locked cant edit other columns

i am trying fixed range of columns should be lock and cannot be edited

try to do it manually (it should be done once):
select all the cells in the worksheet (Ctrl+A), right-click and select - Cells Format - Protection - uncheck 'Protected cell' - Ok