I am using VBA to autofit text within cells. It works great until I protect the sheet. When I enter text in an "unlocked" cell in the protected sheet, the cells autofits the data correctly however then the cells becomes "locked". I cannot go back to update the content. Does anyone have suggestions on how to fix the issue? I am using the script below:
Please Login or Register to view this content.
Bookmarks