Sub Comments_AutoSize()įor Each M圜omments In ActiveSheet.Comments Sub ResetComments()įor comments that have shrunken to thin slivers, you can use this macro to get them back to a normal size. If your comments have slithered across the spreadsheet, you can use this macro to put them back in their parent cell. Use the sample macros below, to fix wandering Excel comments, and to make them the correct size again. What a mess! Fortunately, you can quickly get things back in place, by using an Excel macro or two.
A few comments have wandered far from their cell, and the connecting line stretches across the entire window.Other comments are so small that you can barely read the first word.Some comments have flattened to a thin line.This screen shot shows an example of wandering Excel comments, and incorrect comment sizes. Here’s how to fix those wandering Excel comments. Comments are in the wrong place, and wrong size. Then, for no apparent reason, everything changes. Do you ever open an Excel workbook, and find that tragedy has struck your comments? You spent hours inserting those comments, and making them just the right size and shape.
