probelm when apply locked for cells in protection option and lock scroll

to share information with forum community
i find solution for these error
add the following line to my code that will unprotect worksheet first and at the end of code protect sheet again
ActiveSheet.Unprotect Password:="123456"
ActiveSheet.protect Password:="123456"
so my code will be like the following

Please Login or Register  to view this content.

other thank scroll probelm , when find solution will share it here also

Hi Mazan,

for worksheet protection you can add the following to the ThisWorkbook portion

Please Login or Register  to view this content.

This will eliminate the need to unprotect and protect every time your code runs.

As for the scroll problem, how are you preventing scrolling?

Thank you Robin8114 for your code
for scroll
I want to prevent scroll for sheet name (MyList)
only can scroll column A:E in range from A1:E10014
other than can't scroll

So I did something like this:

in ThisWorbook module have this code

Please Login or Register  to view this content.

that way every time workbook is opened the scrollarea is set

thank you so much robin8114
Also, I made another idea want to share with community here
I hide this range I didn't want from my sheet, shows only will be visible what I want