Home > In Excel > Cannot Edit Comments In Excel
Cannot Edit Comments In Excel
Can't edit a Comment, not protecting, not sharing « Previous Thread | Next Thread » Thread Tools Display Modes #1 November 10th 07, 12:37 AM posted to I have the same problem and for me it has worked. I have tried to have my code send the active cell to another cell and then back, but that doesn't seem to work. Do you have multiple worksheets grouped? -- Richard "tfletch" wrote: > I'm using Excel 2002 on XP, have been for a couple years and all of a sudden > I cannot
DR Anoop S replied to DR on 09-May-10 03:09 AM 1. Over the course of a few days of trying everything unsuccessfully I once again right clicked on a cell and I couldn't see anything. View 9 Replies View Related Allow Edit Of Cell Comments But Not Move Mar 7, 2008 I need to have users be able to modify notes to various pre-set comments on The cell I have the comment on has a dropdown box, but I can't see that being a problem.
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 Is there a way to fix this "invalid reference" error so that I can edit my links with the source workbook open? Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. could you please explain me how did it work ?
Microsoft MVP - Excel Entia non sunt multiplicanda sine necessitate Register To Reply 05-08-2010,05:20 PM #5 Sardonix View Profile View Forum Posts Registered User Join Date 05-08-2010 Location San Diego MS-Off Click the Office Button and then click Excel Options button. 2. Member Login Remember Me Forgot your password? I would like a macro that will remove all comments from the sheet and revert the cells back to their original color.
All contents Copyright 1998-2016 by MrExcel Consulting. http://www.pcreview.co.uk/threads/how-did-i-lose-ability-to-add-edit-comments-in-excel.3837597/ 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 Can't Edit Comments In Excel 2013 View 2 Replies View Related Disable Comments Mar 3, 2008 I am sure this can be done - I found a similar thread but in a different context to what I Edit Comment In Excel Not Working If you're having a computer problem, ask on our forum for advice.
Here's what I did to be able to edit comments again, without any format or position changes. this page Player claims their wizard character knows everything (from books). Log in or Sign up PC Review Home Newsgroups > Microsoft Excel > Microsoft Excel Misc > Why can't I edit my comments in Excel? A few hours of freaking around and the nightmare is over...... Unable To Edit Comments In Excel 2007
I have a user of a workbook who insists on putting irritating red cornered comments in cells, rather than using the handy (and rather large) comments field I put in, especially PASTE SPECIAL> COMMENTS. 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. get redirected here Home » ExcelBanter forum » Excel Newsgroups » Excel Discussion (Misc queries) Can't edit a Comment, not protecting, not sharing Author Name Remember Me?
Hi, I'm using MS Office 2007 and for some reason I can't edit the comments on some of the cells in my Excel spreadsheet. If so, try to open all filters (row numbers on the left will turn black instead of blue), and adjust one comment now., and see if it goes away. –Aganju Dec did you use data validation and not the cell comments for some of those cells??, Of course I can't tell because all you said was that you couldn't edit them... --
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 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 How are the functions used in cryptographic hash functions chosen? Member Login Remember Me Forgot your password?
Is adding the â€˜tblâ€™ prefix to table names really a problem? But normally, the comment will be connected by a line to the cell, so you would just follow the line to find the comment. Everything works great except that after the user selects what they want from the userform and it hides and the focus comes back to the sheet, the comment is in edit useful reference While this is not horrible it is not as nice as I would like.
Note: I know how to print the actual comments - however, the colleague I'm assisting only wants to show that there is a comment without actually showing said comment. Please Login or Register to view this content. I have stumped as well as other forums.