Forum Discussion

Copper Contributor

May 28, 2020

Comments resized to 0 height. Any way to resize all at once?

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...

excel

SergeiBaklan

Diamond Contributor

May 28, 2020

KristyKapsner

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.

KristyKapsner

Copper Contributor

May 28, 2020

SergeiBaklan Any idea how to make it stop happening?

SergeiBaklan
Diamond Contributor
May 28, 2020
KristyKapsner

Unfortunately not, have no idea why that could happen