To delete a Comment:
Select a cell contains a comment, select Review - Delete (in Comments Group).
Or
Right-click and select Delete Comment from the shortcut menu.
? To delete all Comments in a sheet:
1. Press F5 to open the Go To dialog box, and click Special.
2. In the Go To Special dialog box, select Comments.
3. Click OK. All cells containing Comments are selected.
Or
Skip steps 1 through 3 and press Ctrl+Shift+o (the letter o, not the number zero) to select all Comments.
4. Press Shift+F10 or right-click, and select Delete Comment from the shortcut menu.
In this way we can remove comments from excel.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
"Hi Paul,
Sounds like a bug in that application to me.
BTW, not sure if you have a different version of Excel to me, but try checking under INSERT - NAMES - DEFINE too.
Alan."