I am running a loop that changes the value in one cell at a time. Since this is for our entire company, I am trying to make it "idiot-proof" like most of you have done.
While in the loop, I want to unprotect a cell, change the value, then reprotect the cell.
But the rest of the worksheet is going to be unprotected for now.
is that possible? Or do I have to protect the whole sheet, and then .Unprotect the whole sheet first and then .Protect it at the end of the macro.