AwesomeSteph
Board Regular
- Joined
- Aug 18, 2017
- Messages
- 80
I have tried a lot of different code that does not work. What I am looking to do is this: I have an excel template that users should not be able to edit the top portion of a form but they need to be able to add comments to the bottom portion of the form, to do this I have protected the sheet. However now if the users comment is too long they can not view the entire comment so the person the comment is for can't read the entire content of the cell. I have changed the protection so they are able to change the height of the cell manually and this should help for now however a lot of the users are very grumpy and complain about this constantly. Is there a code that will automatically adjust the height of the cell when the comment is larger than the area of the merged cell? I cannot adjust the form to not have these cells merged as the form is corporate and we send to the customers and use it for a java tool that I do not control in order to obtain metrics.