+ Reply to Thread
Results 1 to 1 of 1

VBA to autosize comment box in MS Excel 2011 NOT WORKING in MS Excel 2016

  1. #1
    Registered User
    Join Date
    01-26-2016
    Location
    Jacksonville, FL
    MS-Off Ver
    Office 2016 For Mac
    Posts
    1

    VBA to autosize comment box in MS Excel 2011 NOT WORKING in MS Excel 2016

    The following code which worked well in MS Excel 2011 generates the error below in MS Excel 2016 and I'm unable to resolve the issue!

    Dim Commnt As Comment
    For Each Commnt In Application.ActiveSheet.Comments ' Autosize all comment boxes on the sheet
    Commnt.Shape.TextFrame.AutoSize = True
    Next

    Screenshot 2018-07-18 12.30.51.png

    What's changed and how do I accomplish in MS Excel 2016?

    I neglected to mention the important aspect that I'm now using MS Excel 2016 on a MacBook Pro running macOS 10.12.6 (High Sierra)
    Last edited by Black Panther; 07-18-2018 at 01:10 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Macro built in Excel 2011 crashes workbook in Excel 2016
    By NCRB_10 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-24-2018, 12:31 AM
  2. [SOLVED] Excel MAC 2011/2016 Updating master workbook from second workbook not working
    By shirleyxls in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 05-25-2017, 10:36 AM
  3. [SOLVED] Excel 2016 Using an Unsaved image in a Comment
    By zyzzyva57 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-21-2017, 03:41 PM
  4. Excel 2011. Is there a way to insert a comment for a range of cells?
    By so_fistica_ted in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 5
    Last Post: 07-02-2015, 02:03 PM
  5. Replies: 0
    Last Post: 03-19-2012, 07:32 PM
  6. Macros working fine on Windows Excel, but not on Mac (Excel 2011)
    By mcstenger85 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-08-2012, 08:52 AM
  7. Macros working fine on Windows (Excel 2010), but not on Mac (Excel 2011)
    By six6to8eight in forum Excel Programming / VBA / Macros
    Replies: 17
    Last Post: 01-29-2012, 11:12 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1