Hello all,
I have a protected sheet. The sheet contains also fields which are NOT protected. Is it possible to empty all the unprotected fields at once. Because now I do ite lik this:
Thanks in advance!
I have a protected sheet. The sheet contains also fields which are NOT protected. Is it possible to empty all the unprotected fields at once. Because now I do ite lik this:
Code:
Range("B2").Value = Empty
Range("G6").Value = Empty
Range("G7").Value = Empty
Range("B11").Value = Empty
Thanks in advance!