URGENT: Need to show all comments

[cpis0002]

I have a very large workbook and would like to unhide all the comments so I can see if I need to change any of them.

Instead of gng to each one, I would like them all to show so I could see if I need to update them and if not, I hide them again one-by-one.

Or even better, is there a way to get a list of the text of all the comments in the worbook?

Thanks

 

[Andrew Poulsom]

Tools|Options|View tab, check Comment & indicator.

 

[Jon von der Heyden]

Or to input a list of the comments into a new sheet try this:

Sub b()

Dim cmt As Comment
Dim c As Range
Dim aWs As Worksheet

Set aWs = ActiveSheet

Sheets.Add

For Each c In aWs.UsedRange
    Set cmt = c.Comment
        If Not cmt Is Nothing Then
            Cells(Rows.Count, 1).End(xlUp).Offset(1, 0) = c.Address
            Cells(Rows.Count, 2).End(xlUp).Offset(1, 0) = cmt.Text
        End If
Next c

End Sub

Regards
Jon

 

[pgc01]

Hi

To print the comments enable them in the Page Setup.

For ex. if you choose "comments at end of sheet" you can then only print the pages with the comments.

Hope this helps
PGC

 

[Jack in the UK]

I have a nice exe file format, this question reminded me I really must put it on teh site for everyone - loads of comments stuff in it to help everyone, anyway for now. Does this help these are a few pages that might help You

Show Comment / Show All Comments

Use the Show Comment button to display a single comment.
Select the cell you wish to display a comment for and click the Show Comment button.

The Show All Comments button displays all comments in a spreadsheet

--------
Display All Comments

Choose View
Comments

Note –
All comments in all open workbooks will be displayed.
To hide the comments:
choose View
Comment

-------

To Display/Hide a Comment

Cells with comments will contain a small triangle in the upper left corner of the cell. To display the comments, right click in the cell and select Show Comment from the drop down menu.
To Hide a Comment, right click in the cell and select Hide Comment.

NOTE –
To display all Comments, select View, Comments from the Excel menu or select Show/Hide All Comments on the Reviewing toolbar.

-----

Displaying Cell Comments

Whenever the mouse cursor points to a cell, the comment is displayed:
Move the mouse cursor over cell B3 and watch the comment reappear - the comment is displayed close to the cell, not where it has been positioned
Move the mouse cursor slightly to the right and the comment for cell C3 appears
To permanently display both comments:
Open the View menu and choose Comments
The Reviewing Toolbar will appear:
By default, this appears with the other toolbars at the top of the screen but many users prefer to float it (just drag it onto the worksheet). The buttons on this toolbar include [New/Edit Comment] (if the current cell already has a comment you can edit it, otherwise you get a new comment), go to [Previous Comment] or [Next Comment], [Show/Hide Comment] (just the current one) or [Show/Hide All Comments], and [Delete Comment]. You will be trying some of these out next.
Click on cell B3
Click on the [Hide Comment] button to hide just this comment
Click on the same button again, which is now [Show Comment] - the comment reappears
Click on [Next Comment] twice to move to the other comment (if you are already viewing the last comment a dialog box appears asking you if you would like to circle round to the first one - press <Return> for [OK])
Use [Hide Comment] to hide that one
Finally, click on [Hide All Comments] to hide both the comments

To have comments remain on the screen or disappear from the screen when your pointer is not "over" the cell, use one of the following sets of directions.
Displaying/Hiding Comments: Single Cell
Windows: Right click the cell which contains the comment » select Show Comment or Hide Comment
Macintosh: Press [control] and click the cell which contains the comment » select Show Comment or Hide Comment
Displaying/Hiding Comments: Reviewing Toolbar Option
Select the cell which contains the comment
From the Reviewing toolbar, select show or hide comment
Displaying/Hiding Comments: All Cells
To display/hide all of the comments within the document, from the View menu, select Comments
NOTE: Selecting Comments acts as a toggle turning comments on/off.