I used the following code to automatically re-size a cell to fit the notes entered:
Unfortunately, it keeps setting the range ("Notes") to locked after it runs the re-size code.
Being that the worksheet I am creating deals with locked and unlocked cells for ease of entry by the user, this is creating problems.
As soon as it resizes the range ("Notes"), it locks it, and the worksheet remains protected. Then the user is unable to go back and edit what they typed into the notes range.
Does anyone know where I could insert something to unlock the range during it's resize action?
I have tried to insert things like the following code in random places within the above code, but it continues to lock the range.
Bookmarks