May 28 2020 11:47 AM
All of my comments have been resized to 0 height. See picture attached
I can go to them & click Show/Hide comments & the comment can be selected & I can resize it. Is there any way to resize every comment in the spreadsheet? It also seems like they keep getting reset to 0, so is there a way to stop that? I've used this spreadsheet for years without issue.
Thanks
Kristy
May 28 2020 11:59 AM
Kristy, that's with macro. One sample is here https://www.reddit.com/r/excel/comments/4phot6/macro_to_resize_all_comment_boxes_to_a_specific/, you may google for more.
May 28 2020 12:15 PM
@Sergei Baklan Any idea how to make it stop happening?
May 28 2020 01:07 PM
Unfortunately not, have no idea why that could happen