BlackPanther
07-21-2018, 07:21 PM
Can someone show how to set the size all the worksheet comments boxes in MS Excel 2016 to fit their comments?
In MS Excel 2011, I used the following VBA statements. The red font statement generates an error in MS Excel 2016.
Dim Commnt As Comment
'
For Each Commnt In Application.ActiveSheet.Comments ' Autosize all comment boxes on the sheet
Commnt.Shape.TextFrame.AutoSize = True
Next
'
In MS Excel 2011, I used the following VBA statements. The red font statement generates an error in MS Excel 2016.
Dim Commnt As Comment
'
For Each Commnt In Application.ActiveSheet.Comments ' Autosize all comment boxes on the sheet
Commnt.Shape.TextFrame.AutoSize = True
Next
'