vba Allow Users to Edit Ranges with password
Hello, i have a problem.
I'm using vba, i've created a protected sheet with a table. When I press the button the code unprotects the sheet, adds a row on the top of a table and the other rows go down, and at the end it protect again the sheet. In the protected sheet there is a column whose cells can be modified only with a password ( Allow Users to Edit Ranges with password), but when I add a row i loose this potection for the cell of the new row. Can I use vba to Allow Users to Edit Ranges with password also in the new row?
I hope that my question is clear and the my English is not too bad.