Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
I have several thousand rows and some cells have comments in them and every
time I edit anything it drop or raises all my comments, I have Excel 2002, what can I do about this? Richard |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
Hi there.
Hope the following helps;;; On the menu on top select TOOLS, then move down to select OPTIONS and in the next window that pops up select the VIEW tab, under comments check the small radio button named NONE. click ok "Richard" wrote: I have several thousand rows and some cells have comments in them and every time I edit anything it drop or raises all my comments, I have Excel 2002, what can I do about this? Richard |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comments
Not sure what you're describing or expecting for a solution but maybe
re-position Comments to default? This from Debra Dalgleish. Reset Comments to Original Position If comments have moved out of position, you can reset them using the following code: Sub ResetComments() Dim cmt As Comment For Each cmt In ActiveSheet.Comments cmt.Shape.Top = cmt.Parent.Top + 5 cmt.Shape.Left = _ cmt.Parent.Offset(0, 1).Left + 5 Next End Sub Gord Dibben MS Excel MVP On Thu, 26 Jun 2008 17:08:53 -0700, "Richard" wrote: I have several thousand rows and some cells have comments in them and every time I edit anything it drop or raises all my comments, I have Excel 2002, what can I do about this? Richard |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
pop up comments | Excel Discussion (Misc queries) | |||
in excel useing comments how do you add clip art to comments? | New Users to Excel | |||
Comments. | New Users to Excel | |||
Comments Help | Excel Worksheet Functions | |||
Comments | Excel Worksheet Functions |