Deleting a comment in a cell

tabmak · May 10th, 2002, 08:10 AM

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 · May 10th, 2002, 06:48 PM

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 · May 10th, 2002, 07:06 PM

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

May 10th, 2002, 07:06 PM	#3
Nimrod MrExcel MVP Join Date: Apr 2002 Location: Vancouver BC , Canada Posts: 6,259	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 __________________ <MARQUEE>...........Never be afraid to try something new. Remember, amateurs built the ark, professionals built the Titanic...............The easiest thing to find is fault, don't be easy !.. --Anonymous--...</marquee>

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 08:10 AM	#1
tabmak New Member Join Date: May 2002 Location: Tab Posts: 1	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.

May 10th, 2002, 06:48 PM	#2
Lo Lun To Join Date: May 2002 Posts: 8	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.)