Reply to thread

Message: [QUOTE="PeterAtherton, post: 2980129"] Maria If you do not mind a macro you can modify this. Sub t1() 'this works Set rng = Range("C4:c9") For Each c In rng On Error Resume Next c.Comment.Shape.Select Selection.ShapeRange.Height = 24 Selection.ShapeRange.Width = 49 Next Cells(1, 1).Select End Sub Press ALT + F11, choose insert Module and paste in the code. Return to excel and choose Tools, Macro (ALT + F8) and run the macro. You will need to change the range to cover where your comments are and also play around with the height and width. If this continues then you can assign it to a Form button View, Toolbars, Forms - Click the 4th one and draw it one the worksheet. You will be prompted to assign the code you have placed in the VB Editor. Regards Peter [/QUOTE]