Home > In Excel > Unable To Edit Comments In Excel

Unable To Edit Comments In Excel

Contents

Something must happen to the comments when I adjust their location by using COPY, PASTE SPECIAL, COMMENTS. If the cell's value was to change, for instance the user going back to a cell to change the value for whatever reason, I would like the previous comments to remain Second law of thermodynamics doubt Why credit card information mostly not stolen? To start viewing messages, select the forum that you want to visit from the selection below. weblink

Do I have to unprotect the sheet? My Current Macro that Works Per SheetSub tcktoriginal()'' tcktorginal Macro' macro to run tickets' Range("F4").Select Range("cpt.code.table.").AdvancedFilter Action:=xlFilterCopy, CriteriaRange _ :=Range("A1:S3"), CopyToRange:=Range("A11:S11"), Unique:=False Range("F5").SelectEnd SubExamples That I have Tried and Didnít Work I am often sorting over 3000 lines of data as well as adding and subtracting lines. i dont know how could that problem solved with this basic solution but that is amazing !!! http://www.mrexcel.com/forum/excel-questions/579821-cant-edit-comments-solved.html

Can't Edit Comments In Excel 2010

If I uncheck 'select unlocked cells' then 'select locked cells' unchecks, too. I thought something like, "It's in edit comment mode but its just hidden from me." So then I started thinking, "Where is it hidden." That's when I dragged out the cell, Does anyone know how I can "snap" (for lack of a better word) that comment back to the original cell? Now I cannot edit comments without going to review show all comments and then click on the cell that I have added a comment into.

But normally, the comment will be connected by a line to the cell, so you would just follow the line to find the comment. Regards, Shakeel Ask Your Own Question Adding Comments Into A Protected Worksheet - Excel Excel Forum Hi all, I have a workbook that is used for estimating, Which i have protected I still can edit properly any new comments that I then add, until I need to correct the locations and then those comments are easy to edit. Edit Comment Not Working In Excel Remember Me?

Ask Your Own Question How Do I Export Comments Into Another Excel Column As Cell Content - Excel Excel Forum How do I export comments into another excel column as cell Can't Edit Comments In Excel 2013 Home Cant Edit Comments ... EXCEL Example.xlsx View 3 Replies View Related Unable To Delete 1 Million+ Rows Apr 30, 2009 I've accidentally created over 1 million rows across several sheets which has sent my file Who would of thought of that....

I have checked the 'shared workbook', 'shared worksheet', and 'protected cell' options and they are all turned off (never had them on). Unable To Edit Comments In Excel 2007 I seem to just be ignored. Please help. Same problem has 'bugged' me for years now, 'bugged' being the operative word as I assumed that's what it was, and hence unfix-able.

Can't Edit Comments In Excel 2013

decrease the zoom of the workbook (Ctrl-mouse wheel) until you see the comment box appear on the screen. I still do not know how to re-produce this problem. Can't Edit Comments In Excel 2010 But thanks anyway. Unable To Edit Comment In Excel 2013 If the cells within a4:a23 are blank, how do I ignore them?

In some cases the comments will disappear on one users sheet while showing up on another, this seems to be random and sporadic. http://brrian.net/in-excel/unable-to-edit-cells-in-excel.html The value entered into the cells i want this function to work with is from a Validation list. When I modify the macro (I've tried several ways based on info published here) , the best result i can get is the data copies 6 times in the same page How can I edit a cell without using the mouse? Can't Edit Comments In Excel 2016

  • I encountered exactly the same problem.
  • 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
  • I really need to export the text within the comments onto another column in order to avoid the tedious job of copying and pasting each individual comment.
  • Then end goal in mind is to assign this macro to a button, so the user ,when ready ,can click the button to produce the results.
  • Excel - Tips and Solutions for Excel Privacy Statement Terms of Service Top All times are GMT -4.
  • I was immediately able to edit the comments.
  • worked like a charm.
  • Thanks.

I seem to just be ignored. Sign up now! Most of the comments i have set to "un-hide" and they can be printed. http://brrian.net/in-excel/unable-to-edit-pictures-in-excel.html Here the problem starts.

Register To Reply 05-09-2010,12:23 AM #7 teylyn View Profile View Forum Posts Visit Homepage Forum Guru Join Date 10-28-2008 Location New Zealand MS-Off Ver Win 2010-2016 Posts 11,037 Re: Can't edit Excel Add Comment Share Share this post on Digg Del.icio.us Technorati Twitter redart likes this. All rights reserved.

Anyone got any ideas how i can get roudn this?

Why is Titanic's Astor asking if Jack is from the Boston Dawsons? View 1 Replies View Related Unable To Edit Links With Workbook Open Because Of Invalid Reference? Guest, Jul 4, 2007, in forum: Microsoft Excel New Users Replies: 2 Views: 445 Guest Jul 18, 2007 Lost ability to select multiple cells w/ values & see sum, why? you can float over the cell and see the comment but you cannot edit it.

TIA John Ask Your Own Question Auto Insert Comment Based On Value Entered - Excel Excel Forum Hi Everyone, Is there a way to auto insert a cell Comment when a So I went into the tools - options - views - comments section and chose no comments. One day, I made copy of my file & deleted all the comments in my worksheet & found the filtering activity has been very fast. this content However, when I try to select categories on combo box 2, each time it tries to hide/unhide rows I get this message "Unable to set the hidden property of the range

It should be able to be edited after this repair. The macro works great, but I need a macro to undo the changes. The only fix I could come up with is a bit cumbersome and ineligant. I'd rather not do that, just allow them to add or edit comments in those specific unlocked cells that they can already select.

I have 100's of comments in many cells on a very large workbook. Just started ... I feel like I'm missing something. Add it into your workbook, select all cells you want to re-create the comment, then run this macro.

Interview question "How long will you stay with us?" more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us Register To Reply 09-29-2014,11:31 AM #12 farresto View Profile View Forum Posts Registered User Join Date 10-30-2007 Posts 4 Re: Can't edit comments ... However, i cant seem to be able to add or remove comments to the unlocked cells and i cant see anythign about comments in the 'allow' list when protecting the sheet. Is it possible to have 3 real numbers that have both their sum and product equal to 1?

Indecently the workbook was written in excel 2000 and we have now switched over to 2003. When searching for multiple search words, how would you type the search to include all words, for example, "prevent" & "paste" & "comments". I have a sheet with some data and few of those cells has some comments (right click -> insert comments). I use Excel 2007 if it's any help.

The only comment option in the right click > menu is "delete", which appears in those cells with existing comments. Is it possible to have 3 real numbers that have both their sum and product equal to 1? Thread Tools Show Printable Version Subscribe to this Thread… Rate This Thread Current Rating ‎ Excellent ‎ Good ‎ Average ‎ Bad ‎ Terrible Display Linear Mode Switch to Hybrid Mode Results 1 to 4 of 4 1Likes Top All This Page 1 Post By rifpool Can't edit comments - SOLVED!This is a discussion on Can't edit comments - SOLVED!

as you can see in the image, these options are greyed out.Running Office standard 2010, Windows 7 pro x64 View 8 Replies View Related Prevent Copy / Paste Cells With Comments how to identify them to edit and/or delete them.