 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006Delete comments
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 How do you try to delete them Tony ?  SignatureRegards 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 I right click then chose "Delete Comment." -Tony How do you try to delete them Tony ? -- Regards Ron de Bruin http://www.rondebruin.nl "Tony" <tsheehan@tji-holdings.com> wrote in message news:uSnKQGwGHHA.924@TK2MSFTNGP02.phx.gbl... 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 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 SignatureRegards Ron de Bruin http://www.rondebruin.nl I right click then chose "Delete Comment." -Tony "Ron de Bruin" <rondebruin@kabelfoon.nl> wrote in message news:uqWZ8xwGHHA.4116@TK2MSFTNGP05.phx.gbl... How do you try to delete them Tony ? -- Regards Ron de Bruin http://www.rondebruin.nl "Tony" <tsheehan@tji-holdings.com> wrote in message news:uSnKQGwGHHA.924@TK2MSFTNGP02.phx.gbl... 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
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.