Delete comments

[Tony]

I have an excel document that contains some comments that I need to delete. However, when I attempt to delete them Excel locks up. Does anyone know why this is and how to stop it from locking up?

Thank you in advance,
Tony

 

[Ron de Bruin]

How do you try to delete them Tony ?



--

Regards Ron de Bruin
http://www.rondebruin.nl



I have an excel document that contains some comments that I need to delete. However, when I attempt to delete them Excel locks up. Does anyone know why this is and how to stop it from locking up?

Thank you in advance,
Tony

 

[Tony]

I right click then chose "Delete Comment."

-Tony
How do you try to delete them Tony ?



--

Regards Ron de Bruin
http://www.rondebruin.nl



I have an excel document that contains some comments that I need to delete. However, when I attempt to delete them Excel locks up. Does anyone know why this is and how to stop it from locking up?

Thank you in advance,
Tony

 

[Ron de Bruin]

Strange

Try this macro on a copy of your workbook to delete all comments

post back with the result

Sub Comments1()'This will delete all comments ActiveSheet.Cells.ClearCommentsEnd Sub

--

Regards Ron de Bruin
http://www.rondebruin.nl



I right click then chose "Delete Comment."

-Tony
How do you try to delete them Tony ?



--

Regards Ron de Bruin
http://www.rondebruin.nl



I have an excel document that contains some comments that I need to delete. However, when I attempt to delete them Excel locks up. Does anyone know why this is and how to stop it from locking up?

Thank you in advance,
Tony