Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Comments will not delete from Worksheet
Hi First post - be gentle! I am unable to delete Comments from one of my worksheets. When I try the machine just hangs (eggtimer) forever and the only way out is to Ctrl/Alt/Del. It only happens on this one worksheet - Comments on other Excel files delete OK. I have not knowingly "protected comments" on this one or anything similar. Any ideas as to what has happened? Thanks Grockle -- grockle ------------------------------------------------------------------------ grockle's Profile: http://www.excelforum.com/member.php...o&userid=26964 View this thread: http://www.excelforum.com/showthread...hreadid=401822 |
#2
|
|||
|
|||
Are you sure that the worksheet itself is not protected?
-- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "grockle" wrote in message ... Hi First post - be gentle! I am unable to delete Comments from one of my worksheets. When I try the machine just hangs (eggtimer) forever and the only way out is to Ctrl/Alt/Del. It only happens on this one worksheet - Comments on other Excel files delete OK. I have not knowingly "protected comments" on this one or anything similar. Any ideas as to what has happened? Thanks Grockle -- grockle ------------------------------------------------------------------------ grockle's Profile: http://www.excelforum.com/member.php...o&userid=26964 View this thread: http://www.excelforum.com/showthread...hreadid=401822 |
#3
|
|||
|
|||
No Chip, I'm pretty sure it is not protected. I dont get the choice to "unprotect sheet" on the TOOLS menu anyway. Other worksheets in the workbook are OK as are other files. It's wierd. Grockle -- grockle ------------------------------------------------------------------------ grockle's Profile: http://www.excelforum.com/member.php...o&userid=26964 View this thread: http://www.excelforum.com/showthread...hreadid=401822 |
#4
|
|||
|
|||
The one time I had a corrupted worksheet, I think the number of comments was
partially to blame (there were lots!). Do you have lots of comments? Are you trying to delete all of them? Maybe clearing comments from a smaller range would help--or even one at a time? Maybe using a macro would help (or maybe not!): Option Explicit Sub testme() Dim cmtCtr As Long With ActiveSheet For cmtCtr = 1 To .Comments.Count .Comments(1).Delete Next cmtCtr End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm === If all this fails, you may want to post more info on how you're trying to delete the comments. (or start rebuilding that worksheet?????) grockle wrote: Hi First post - be gentle! I am unable to delete Comments from one of my worksheets. When I try the machine just hangs (eggtimer) forever and the only way out is to Ctrl/Alt/Del. It only happens on this one worksheet - Comments on other Excel files delete OK. I have not knowingly "protected comments" on this one or anything similar. Any ideas as to what has happened? Thanks Grockle -- grockle ------------------------------------------------------------------------ grockle's Profile: http://www.excelforum.com/member.php...o&userid=26964 View this thread: http://www.excelforum.com/showthread...hreadid=401822 -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"how can i format all the comments in a worksheet together?" | Excel Discussion (Misc queries) | |||
macro to copy and edit then delete a worksheet | Excel Discussion (Misc queries) | |||
How do I delete one worksheet from a different one? | Excel Discussion (Misc queries) | |||
Protect Worksheet but allow to insert or delete rows | Excel Discussion (Misc queries) | |||
how do I delete data from a worksheet without deleting the formul. | Excel Discussion (Misc queries) |