Allowing user input only to to diffrent columns

[ylijohe]

How could I protect the spreadhseet from user input except to two ranges:
I10:I200 and O10:O200?

 

[Paul B]

select the range you want to be able to put data in and then go to format, cells, protection and uncheck locked then protect the sheet

 

[ylijohe]

Thanks, it worked....

Now it does not allow reading data from internet, I suppose I have to add a sub that takes the protection off before reading data and closes the sheet from writing after it?

This is interesting!

 

[Paul B]

ylijohe,In case you have not fine the answer use
ActiveSheet.Unprotect
Your code
ActiveSheet. protect