Consulting

Results 1 to 2 of 2

Thread: VBA To Size Comment Boxes In MS Excel 2016 For Mac High Sierra?

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1

    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



    Last edited by Aussiebear; 03-22-2025 at 02:33 PM.

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
  •