PC Review
Home Forums Reviews Articles Register
Member Login:

PC Review > Forums > Newsgroups > Microsoft Excel > Microsoft Excel Discussion > Delete comments

Reply
Thread Tools Rate Thread

Delete comments

 
 
Tony
Guest
Posts: n/a
 
      8th Dec 2006
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 With Quote
 
 
 
 
Ron de Bruin
Guest
Posts: n/a
 
      8th Dec 2006
How do you try to delete them Tony ?



--

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



"Tony" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
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 With Quote
 
Tony
Guest
Posts: n/a
 
      8th Dec 2006
I right click then chose "Delete Comment."

-Tony
"Ron de Bruin" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
How do you try to delete them Tony ?



--

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



"Tony" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
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 With Quote
 
Ron de Bruin
Guest
Posts: n/a
 
      8th Dec 2006
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



"Tony" <(E-Mail Removed)> wrote in message news:%(E-Mail Removed)...
I right click then chose "Delete Comment."

-Tony
"Ron de Bruin" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
How do you try to delete them Tony ?



--

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



"Tony" <(E-Mail Removed)> wrote in message news:(E-Mail Removed)...
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 With Quote
 
 
 
Reply

« Using INDIRECT | Formula Question »
Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Comments - Delete All? =?Utf-8?B?cHJvb2ZyZWFkZXI=?= Microsoft Word Document Management 1 26th Feb 2007 09:58 PM
Is it possible to delete all comments at once? =?Utf-8?B?QmxhaXNl?= Microsoft Word Document Management 2 16th Jul 2005 12:51 AM
Delete Comments Bruce Microsoft Word Document Management 2 2nd Sep 2004 11:59 AM
Delete all comments George Hill Microsoft Word Document Management 6 19th Mar 2004 12:01 AM
can't delete comments Stephanie Microsoft Word Document Management 2 23rd Dec 2003 02:32 PM


Features
Forums Startup Database Reviews Articles FAQ / Guidelines About Us
 

Advertising
 

Newsgroups
Windows Vista Windows XP Microsoft Word Microsoft DotNet Windows 2000 AntiSpyware Microsoft Access Microsoft Excel Microsoft Outlook Hardware
 


All times are GMT +1. The time now is 07:03 PM.
Powered by vBulletin®. Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2010, Crawlability, Inc.
Contact Us - Archive - Privacy Statement - Top