K
kalpesh
Hello
l would like to lock scroll area in sheet1 in range A1:H10 when sheet 1
activat
the code is given unde
Sub LockArea(
Worksheets(1).ScrollArea = "A1:F10
End Su
Private Sub Worksheet_Activate(
Call LockAre
End Su
but problem is when file is close & again open this file scroll area i
unlock so i first select sheet2 & then select sheet1 then scroll area i
loc
i like when every time file is open the sheet 1 scroll area is lock whithou
select sheet
how
l would like to lock scroll area in sheet1 in range A1:H10 when sheet 1
activat
the code is given unde
Sub LockArea(
Worksheets(1).ScrollArea = "A1:F10
End Su
Private Sub Worksheet_Activate(
Call LockAre
End Su
but problem is when file is close & again open this file scroll area i
unlock so i first select sheet2 & then select sheet1 then scroll area i
loc
i like when every time file is open the sheet 1 scroll area is lock whithou
select sheet
how