Deleting a comment in a cell

[tabmak]

I have (hidden) comments inserted in various cells throughout my spreadsheet. When I attempt to delete the comment, the mouse turns to an hourglass and then freezes the entire spreadsheet. I don't believe it is a problem with my PC, cause I've transferred the spreadsheet to an alternate PC to have the same problem appear again.

 

[Lo Lun To]

You could try doing it with a macro (can't say whether or not it will work :-

Sub Delete_Comments()
Selection.ClearComments
End Sub

Select the cell(s) first then run the macro.

(Note: I got the code from the macro recorder.)

 

[Nimrod]

Idea1
1- copy sheets to new workbook and see if problem goes away

Idea2
2- Select all of sheet and select copy
- on new sheet do several paste specials until you've pasted over all accept the comments