Threaded comment excel как исправить

With Excel comments, you can put a quick note in a cell, to explain a cell’s value. A new type of comment is coming to Excel soon, and here is a warning, before you make the switch.

Insert a Comment

Comments have been available in Excel for many years, and they’re handy for adding extra info to a cell.

For example, a region’s sales might have been low one month because of bad weather. Point to that cell, and the popup comment shows the reason.

For information on the basics of inserting, showing and printing comments, go to the Getting Started with Comments page on my Contextures site.

Comment Tricks

After you insert Excel comments, you can jazz them up a bit, with shapes, colours and pictures.

You wouldn’t want to fill a worksheet with these eye-catching comments, but use them occasionally, to add impact.

See how to change comment shapes, and add comment pictures on my Excel Comment Tips page.

Threaded Comments

Microsoft is introducing Threaded Comments in Office 365, so you might see those soon, if you don’t have them already. It should be available now, if you get the Insider builds.

These new threaded comments look more like blog comments, than the old-style Excel comments.

Your company might want to use threaded comments in some worksheets, to keep track of a discussion, and remember who said what.

Be careful though, if you’re using the extra comment formatting features.

WARNING – Before You Switch

Before you switch to Threaded Comments, instead of old-style (Legacy) comments, be sure to understand which features you will lose.

Legacy comment formatting features, such as changing shapes, inserting pictures or adding colors, will not be available in Threaded comments.

Affect New and Existing Comments

That formatting limitation doesn’t only affect new comments that you insert. Existing comments will be changed too.

Thanks to Bill Jelen (Mr. Excel) for this warning — “If you try to edit an old comment, a long message will tell you to Convert to Threaded Comments and all of your comment formatting will be lost.”

Insert Old-Style Comments

Excel’s old-style (Legacy) comments will still be available, but the icons to create and edit them will be hidden.

To continue working with Legacy comments, add the following icons to the Quick Access Toolbar, or to the Excel Ribbon:

• New/Edit Comment (Legacy)
• Previous Comment (Legacy)
• Next Comment (Legacy)
• Show/Hide Comments (Legacy)
• Show All Comments (Legacy)

Vote for Legacy Comments

Do you use Legacy Comments, and their special formatting features?

If you’d like to keep your Legacy comments safe, after Threaded Comments are introduced, go to UserVoice, and vote for Bill’s suggestion.

Bill suggests that the right-click menu does not offer a “Reply to Comment” command, for Legacy comments. Or, add an Edit Comments (Legacy) command on the right-click menu, to reduce the chance of destroying the formatting.

The more votes there are, the more likely it is that Microsoft will put the suggestion on their To-Do list.

Threaded Comments Video

To learn more about Excel Threaded Comments, and how to work with Legacy Comments, watch this video by Bill Jelen.

Your browser can’t show this frame. Here is a <a href=”https://youtu.be/3Pgf5FVNPWs” rel=”nofollow” target=”_blank”>link</a> to the page

___________________

My office just upgraded to a new version of Office 365, and with it came a new way that comments are done. The old comments are now referred to as «notes» and the new comments are now called «comments».

In one of my workbooks, I have a button that, when clicked, will look through certain cells to check whether there is a comment or not. It will then color the cell based on what it finds.

(my full code for the button is posted below)
Line 9 contains the issue

In previous versions of Excel, this button worked just fine. However, now it only works if the cells have «notes» and does not work if they have «comments». In my code, the class that I had been using was called «Comment», so my code was something along the lines of «If Cells(row, col).Comment Is Nothing…». This class still works, but only looks for notes. I have looked through the Object Library and under the hidden objects, I found a new class called «CommentThreaded». I tried changing my code to that («If Cells(row, col).CommentThreaded Is Nothing…») but it does not work. When I click the button, I now get a run-time error: applictaion-defined or object-defined error when it tries to access this new class.

Does anyone know what I need to change to get my button to work with threaded comments?

Thanks,
Mike

Sub Comments()
Dim xrow As Integer
Dim xcol As Integer

For xrow = 7 To 88
    For xcol = 3 To 15
        If Cells(xrow, xcol).Value <= -0.1 Or Cells(xrow, xcol).Value >= 0.1 Then
            If Cells(5, xcol).Value = "MTD %" Or Cells(5, xcol).Value = "YTD %" Then
                If Not Cells(xrow, xcol).Comment Is Nothing Then
                    Cells(xrow, xcol).Interior.Color = RGB(155, 255, 188)
                Else
                    Cells(xrow, xcol).Interior.Color = RGB(255, 255, 0)
                End If
            End If
        End If
    Next xcol
Next xrow
End Sub

Bug report

When an Office 365 comment is loaded, the following warning is shown:
«[Threaded comment]
Your version of Excel allows you to read this threaded comment; however, any edits to it will get removed if the file is opened in a newer version of Excel. Learn more: https://go.microsoft.com/fwlink/?linkid=870924

The comment appears in Excel as follows:

Reproduction of the problem

1. Go to demo — https://demos.telerik.com/kendo-ui/spreadsheet/index
2. Import a file from ticket — 1447268

Current behavior

A warning is displayed

Expected/desired behavior

No warning is displayed

Environment

• Kendo UI version: 2019.3.1023
• Browser: all