vba Allow Users to Edit Ranges with password

Elisabetta 1 Reputation point
2021-12-16T12:32:33.007+00:00

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.

Thank you.

0 comments No comments
{count} votes