View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
LPS LPS is offline
external usenet poster
 
Posts: 108
Default Editing Comments - Excel 2000

Using Excel 2000, one numeric column has a number of comments in various
cells. By pointing at the comment indicator I can dislay the comments and by
right-clicking over it I can delete the comments but I cannot edit the
comments. This is with the exception of the last comment (in the same column
and range), which I can edit. The sheet is not protected, I do not have
multiple sheets selected, the freeze panes option is off, and all the cells
are formatted as currency.

I can edit comments in all other columns except this one.

Can anyone suggest why I can edit the last one but not the others. I have
tried copying and special pasting to a new column and nothing changes.

Thanks muchly for all suggestions / help.
--
LPS