-
VBA To Size Comment Boxes In MS Excel 2016 For Mac High Sierra?
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
'
Tags for this Thread
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules