Hide resolved comments

Question

I'm wondering if there's anyway to hide resolved comment threads in excel. (Using Office 365)

We use the comments quite a bit, as it's a useful way to leave feedback and follow up on things, so we'd like to keep the comment history there once they've been resolved so we can easily see why decisions were made without having to load up earlier versions from onedrive history.

However when I'm going through looking for feedback, all the comments have the purple icon visible and it's not until I hover over it that I can see if the comment thread is active or resolved. This results in me wasting a bit of time looking for the active comment threads that still require actions.

I'd love to be able to either colour resolved comment threads different to the regular purple so I can see which ones are active at a glance, or select a view option to hide resolved threads, either way so I can focus on what's still active.

Is there any way to do this?

Kind regards,

Michael

Answer 1

Hi,

The following response pertains to Comments . . NOT Notes.

Please check whether the following solution is helpful:

- In the above screenshot > in the worksheet > there are 3 comments:

i. in cell C4

ii. in cell I11

iii. in cell S26

- Of the 3 comments > 1 comment is resolved, comment in cell S26.

- When the following code is executed > for only resolved comments > cell color changes to green.

Sub Comment_Color()

Dim CommentLoop As CommentThreaded

For Each CommentLoop In ActiveSheet.CommentsThreaded

If CommentLoop.Resolved = True Then

ActiveSheet.Range(CommentLoop.Parent.Address).Interior.Color = VBA.RGB(169, 208, 142) 

End If

Next

End Sub

- The code changes cell colour > for resolved comments > in active worksheet.

Solution workbook link: Format_Resolved_Comments.xlsm

• To make it User-friendly > in the Solution workbook > I have assigned the macro > to an icon (top-left corner in the below screenshot).

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!

Answer 2

Hi, thanks for your response.

I was really hoping for a solution that didn't require macros, as that creates more opportunities for people to mess things up.
To be honest I'm surprised that there's not a simple view option in settings for hiding or viewing resolved threads, as every other system I've worked with that has some kind of comments system allows for this basic functionality.

Answer 3

This question has been discussed here earlier too. Unfortunately, basis the responses here, there is not much that could be done in this situation.

Except VBA, of course.

Please respond if You require further assistance. I will try My best to be of help.

If I was able to help You, please mark My response as answer and helpful.

Thank You!

Answer 4

Thanks again, I think from our perspective, VBA is more hassle than its worth in this situation.

I'll mark your original response as the solution, as maybe if other people are looking for the same function VBA will help them, and if they're curious the rest of the thread will clarify.