Hello everyone, I have a little problem that I'm sure I'm not the only one facing. On my Excel page, throughout the month, I make comments on the cells. At the end of the month, I sort through them and I would like to hide, just hide, most of the comments and keep only a few here and there. So far, I've done it cell by cell but it's a monumental task... and I'm not Roman ;-)) I found a system online but it either removes all comments from the entire page or shows them all with big lines connecting the comments across the page. (Review, comments, show/hide all comments). Moreover, I couldn't figure out how to undo the action, which would have allowed me to restore everything properly. I'm on Windows 10 and not very skilled with computers (big issue with the vocabulary)... If anyone knows how to hide comments "in bulk", I would greatly appreciate it and thank you in advance. Configuration: Windows / Firefox 96.0 S.H. From knowledge comes light, and vice versa.

Re, VBA stands for Visual Basic for Applications, in simple terms, it is a programming language that allows the use of Visual Basic code to execute the many features of the Excel Application. In the earlier versions of Excel, this language was written in the local language, nowadays it's in English, which requires some knowledge. For example, this piece of code entered in the properties of an ActiveX button allows displaying the comments of the selected cells or hiding it if the comment is currently shown. Option Explicit Private Sub CommandButton1_Click() Dim Cel As Range Application.ScreenUpdating = False On Error Resume Next For Each Cel In Selection If Cel.Comment.Visible Then ' ------------ if the comment is visible Cel.Comment.Visible = False ' -------- the comment is hidden Else Cel.Comment.Visible = True ' --------- if not, show the comment End If Next On Error GoTo 0 End Sub A+ Mike-31 I am responsible for what I say, not for what you understand...

View original (French)

Excel: how to hide comments... "in bulk" - Page 2

Solved

Réponse 21 / 22

Mike-31 Posted messages 18405 Registration date Status Contributeur Last intervention 5 145

Hi,

the windows of How it works have changed a bit; to change the status to resolved, you need to scroll to the top of the discussion and at the bottom right of your request, you will see three horizontal dots . . .
click on it and then click on mark as resolved

If you haven't done it this afternoon, I'll do it for you.

--
See you later
Mike-31

I am responsible for what I say, not for what you understand...

Réponse 22 / 22

Sherlock Hoimes Posted messages 134 Registration date Status Membre Last intervention 1

Thank you for everything!
I had tried, but in the course of the discussion. So it wasn't working.
Good luck...
--
S.H.
From knowledge comes light and vice versa.

Excel: how to hide comments... "in bulk" - Page 2

Texture issues in enshrouded

Announcement: online source code archive

Samsung tv music on startup

Écrire o barré avec un clavier azerty

Application extension issue on ps4

Orange unlimited numbers

Text messages from 36111

Tomb raider anniversary on wii

Notice shows wr30 m

Search for a song in the series foudre