LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Can't edit a Comment, not protecting, not sharing

I have Excel 2007, but have saved my worksheet as both native and excel
97-2003 in order to see if it fixes my problem. My problem is I have created
several comments on over 100 different cells and many (not all) of them are
unable to be edited. I seem to just be ignored. you can float over the cell
and see the comment but you cannot edit it.

Don't think it matters but I am using Autofilter. I can say that many of
the comments that I CAN edit are up on my title row where the autofilter is.
If I delete the comment from the cell and manually create a new one in that
cell, i CAN edit it.

Does any of this have to do with converting it from Excel 2007 back to
saving as Excel 97-2003? I can't undo it.

Help!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA to edit a comment Brent E Excel Discussion (Misc queries) 3 November 6th 07 12:15 AM
Sharing and protecting sections of a worksheet. Ekazakoff Excel Discussion (Misc queries) 1 August 9th 06 02:59 AM
protecting sheet blocking comment creation Amadis Excel Discussion (Misc queries) 3 March 9th 06 11:47 AM
How can I edit a comment w/o first having to select Show Comment Mary Ann Excel Discussion (Misc queries) 1 August 26th 05 12:34 AM
cannot edit comment deo89 Excel Discussion (Misc queries) 4 August 24th 05 05:20 PM


All times are GMT +1. The time now is 03:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"