Home > In Excel > Unable To Edit Comments In Excel 2010

Unable To Edit Comments In Excel 2010

Contents

View 11 Replies View Related Unable To Edit Macro To Loop Correctly Oct 22, 2009 I need the macro I created to run (when assigned to a button) in specific sheets How do I print the last 5 fields in awk? Nov 22, 2009 I would like to copy and paste comments from one cell to another. Nice work in finding this fix Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote « Previous Thread | Next Thread » Like this thread? his comment is here

If this is the case, you need to drag the comment back to near the cell. It's not clear to me why track changes / workbook sharing result in this behavior. (Could be a bug or a feature, though it sure seems like a UI bug when Similar Threads How can I pre format all Excel comments Guest, Dec 9, 2004, in forum: Microsoft Excel New Users Replies: 1 Views: 324 Dave Peterson Dec 9, 2004 how to View 1 Replies View Related Unable To Hide Columns/delete Values Using Combo Box Apr 24, 2007 Using two Combo Boxes, I am trying to create an drop down outline form input https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_other/cannot-edit-excel-cell-comment/f690330d-1357-e011-8dfc-68b599b31bf5

Can't Edit Comments In Excel 2013

I now have to click on the cell with the comment, REVIEW > SHOW ALL COMMENTS, then click on the cell, now I can edit the comments, and then back to May 19, 2006 I'm attempt to automatically validate QTP spreadsheets with an EXCEL VBA macro. When I hover the mouse over it, the cursor turns to a circle with a sloped line inside and I can't click the box at all. 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.

Share Share this post on Digg Del.icio.us Technorati Twitter Reply With Quote Sep 29th, 2011,04:36 AM #2 muricci New Member Join Date Sep 2011 Posts 1 Re: Can't edit comments - Browse other questions tagged microsoft-excel-2010 or ask your own question. How to fix! Unable To Edit Comments In Excel 2007 I must have mis-typed something because suddenly I found myself on a different sheet in the workbook and now I cannot insert or edit comments in any cells in the workbook.

Edit buttons shaded. Unable To Edit Comment In Excel 2013 ERROR The requested URL could not be retrieved The following error was encountered while trying to retrieve the URL: http://0.0.0.1/ Connection to 0.0.0.1 failed. When I select the option 2 on the combo box 1, it unhides a bunch of rows, and activates combo box 2. http://www.pcreview.co.uk/threads/how-did-i-lose-ability-to-add-edit-comments-in-excel.3837597/ If they do contain comments then I want to overwrite with my comments.

Golf a Numerical Growing Braid Can I disarm and immediately grapple with Tavern Brawler? Excel Add Comment Explain it to me like I'm a physics grad: Global Warming I want to become a living god! The closest thing to a solution I have found is that it has something to do with beeing in "Design Mode" however, the design button is greyed out, along with much Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.

  1. Is there a method to globally remove all comments from a worksheet?: D What I actually want to do is add comments to cells which fail validation but some of these
  2. I have forgotten what the puzzle was Identify shape of the polygons: elongation, roundness, etc Word for fake religious people Checking to see if a string is alphabetic How to respond
  3. I have the same problem and for me it has worked.
  4. Can a typeface be designed to have characters depend on previous characters within a typed word?
  5. 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?
  6. Other commented cells in the sheet remain OK to edit.

Unable To Edit Comment In Excel 2013

They were created through macros copying columns and pasting them elsewhere, although I'm not sure how they decided that 4-800 rows of data was worth a million rows. Drag the comment box out to the right. Can't Edit Comments In Excel 2013 Jones >NAUTIC Video > >"Gord Dibben" wrote: > >> I would guess that OP has more than one sheet selected. >> >> If sheet was protected "delete comment" would also be Can't Edit Comments In Excel 2016 The way that I correct this is to COPY the entire tab, and then open a new workbook.

I didn't know it was even possible to group >sheets. this content All is going well but I now want to look smarter. Unable To Edit Links With Workbook Open Because Of Invalid Reference? Excel behaves strange when a comment is adjusted while lines are hidden or views are fixed. Edit Comment Not Working In Excel

By the way, the same text I enter or modify put in this "way", I need to modify in the MSWord document and viceversa. could you please explain me how did it work ? more hot questions question feed about us tour help blog chat data legal privacy policy work here advertising info mobile contact us feedback Technology Life / Arts Culture / Recreation Science weblink Why does a (D)DoS attack slow down the CPU and crash a server?

share|improve this answer answered May 28 '15 at 14:36 Keith Bornmann 112 add a comment| up vote -2 down vote The solution is to click on the "Developer" menu -> Insert Neither Office 2010 nor Office 2013 could open it. View 9 Replies View Related Create A Comments Box Via VBA Jul 26, 2008 I want to create a comments box whenever a cell is double clicked in sheet "Settlements" View

Where should a galactic capital be?

What is a "frozen ATPL"? worked like a charm. Next I went to the toolbar and selected "undo". I then reverse the sequence back to the original tab and the comments are now back to where they are suppose to be.

is the workbook shared? "Unless otherwise stated all my comments are directed at OP" Mojito connoisseur and now happily retired where does code go ? Home Submit Resource Tracker Forum Advance Search Unable To Delete Or Edit Comments Feb 9, 2009 I have a comment which I wish to edit, but I am unable to either How to select a good sleeping bag liner How would people living in eternal day learn that stars exist? http://brrian.net/in-excel/unable-to-delete-worksheet-in-excel-2010.html cannot select any of them to edit or delete them, I can type in the cell behind the symbol, the symbol hides the text.

I am using excel 2003 on a Vista machine. Do streams take advantage of branch-prediction? durkbarn, May 25, 2008, in forum: Microsoft Excel New Users Replies: 1 Views: 895 ShaneDevenshire May 25, 2008 Why does an Excel 2007 file lose its format when reopened? View 1 Replies View Related Macro To Delete Comments And Unhighlight Cells Oct 24, 2007 I am having trouble writing a macro to do the following.

To many to redo. You could also try this: righ-click the cell and select "show comment". Everything worked just as it did prior to the issue popping up suddenly and without reason. LinkBack LinkBack URL About LinkBacks Bookmark & Share Digg this Thread!Add Thread to del.icio.usBookmark in TechnoratiTweet this thread Thread Tools Show Printable Version Display Linear Mode Switch to Hybrid Mode

Is there a way to convert these comments into a microsft word document along with the contents of the cells to identify where they originated? Not the answer you're looking for? This problem has bugged myself and others for along time. I have 100's of comments in many cells on a very large workbook.

share|improve this answer answered Jan 23 at 2:22 Ed Denmark 11 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign I had the same issue, and the problem was that I accidentally had 2 sheets selected and didn't notice. 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, Drag that column out to make it wider, then click "Edit Comment." You should see that its "underneath" that cell.

I'm using Excel 2007. I'm not sure how to interpret this code, so I'm sure it's probably easy:cCom.Text Text:=rCell.Text & " " & cCom.Text View 3 Replies View Related Word Document Of Comments Feb 22, View 11 Replies View Related Pictures For Comments May 18, 2008 im using comments to display images for easy look upwhen i save a picture i want it to be that Right click on one of the sheets and "Ungroup Sheets" worked for me.