+ Reply to Thread
Results 1 to 7 of 7

Comments.

  1. #1
    DB.
    Guest

    Comments.

    I have two workbooks which have comments on a few of their cells.
    As is appropriate, when I point to each of those cells the comments they
    contain appear alongside.
    But often (not always), after I have saved the workbook then opened it
    up again on my return, I find that none of my comments appears when I point
    at it.
    Comments can be made visible again by selecting any cell containing a
    comment, clicking Insert --> Edit Comment, then exiting without changing
    anything. All comments on that worksheet are now available to me.
    Next time I return to the workbook my comments may be available - or,
    equally, they may not.
    Can anyone explain to me what is happening here, please?

    --
    DB.




  2. #2
    SteveW
    Guest

    Re: Comments.

    Nobody at Microsoft can explain comments

    I have a file with a major use for comments - its a real pain in the nec=
    k.
    Like you say they jump up all over the place when you go to edit them.
    you can't search them (easily)

    They could have been a really useful addition but imo they (microsoft) =

    missed a trick here.



    On Tue, 18 Jul 2006 15:46:16 +0100, DB. <[email protected]> wro=
    te:

    > I have two workbooks which have comments on a few of their cells.
    > As is appropriate, when I point to each of those cells the comment=

    s =

    > they
    > contain appear alongside.
    > But often (not always), after I have saved the workbook then opene=

    d =

    > it
    > up again on my return, I find that none of my comments appears when I =

    =

    > point
    > at it.
    > Comments can be made visible again by selecting any cell containin=

    g a
    > comment, clicking Insert --> Edit Comment, then exiting without changi=

    ng
    > anything. All comments on that worksheet are now available to me.
    > Next time I return to the workbook my comments may be available - =

    or,
    > equally, they may not.
    > Can anyone explain to me what is happening here, please?
    >




    -- =

    Steve (3)

  3. #3
    DB.
    Guest

    Re: Comments.


    On Tue, 18 Jul 2006 15:46:16 +0100, DB. <[email protected]> wrote:

    > I have two workbooks which have comments on a few of their cells.
    > As is appropriate, when I point to each of those cells the comments
    > they contain appear alongside.
    > But often (not always), after I have saved the workbook then opened
    > it up again on my return, I find that none of my comments appears when I
    > point at it.
    > Comments can be made visible again by selecting any cell containing a
    > comment, clicking Insert --> Edit Comment, then exiting without changing
    > anything. All comments on that worksheet are now available to me.
    > Next time I return to the workbook my comments may be available - or,
    > equally, they may not.
    > Can anyone explain to me what is happening here, please?
    >



    "SteveW" replied:

    Nobody at Microsoft can explain comments

    I have a file with a major use for comments - its a real pain in the neck.
    Like you say they jump up all over the place when you go to edit them.
    you can't search them (easily)

    They could have been a really useful addition but imo they (Microsoft)
    missed a trick here.


    Thanks, Steve.

    I now notice that if I have my worksheet (comments available) open in
    one window and open Outlook Express in another, then the comments are no
    longer available. But my workbook has two sheets, and if I tab to the other
    sheet, then tab back again I get the comments again!
    I imagine your "Nobody at Microsoft can explain comments " may best
    sum it up!
    --
    BW's,
    DB.




  4. #4
    Dave Peterson
    Guest

    Re: Comments.

    Why can't you search them easily?

    Edit|find|Options button|Look in Dropdown|Comments

    "DB." wrote:
    >
    > On Tue, 18 Jul 2006 15:46:16 +0100, DB. <[email protected]> wrote:
    >
    > > I have two workbooks which have comments on a few of their cells.
    > > As is appropriate, when I point to each of those cells the comments
    > > they contain appear alongside.
    > > But often (not always), after I have saved the workbook then opened
    > > it up again on my return, I find that none of my comments appears when I
    > > point at it.
    > > Comments can be made visible again by selecting any cell containing a
    > > comment, clicking Insert --> Edit Comment, then exiting without changing
    > > anything. All comments on that worksheet are now available to me.
    > > Next time I return to the workbook my comments may be available - or,
    > > equally, they may not.
    > > Can anyone explain to me what is happening here, please?
    > >

    >
    > "SteveW" replied:
    >
    > Nobody at Microsoft can explain comments
    >
    > I have a file with a major use for comments - its a real pain in the neck.
    > Like you say they jump up all over the place when you go to edit them.
    > you can't search them (easily)
    >
    > They could have been a really useful addition but imo they (Microsoft)
    > missed a trick here.
    >
    > Thanks, Steve.
    >
    > I now notice that if I have my worksheet (comments available) open in
    > one window and open Outlook Express in another, then the comments are no
    > longer available. But my workbook has two sheets, and if I tab to the other
    > sheet, then tab back again I get the comments again!
    > I imagine your "Nobody at Microsoft can explain comments " may best
    > sum it up!
    > --
    > BW's,
    > DB.


    --

    Dave Peterson

  5. #5
    SteveW
    Guest

    Re: Comments.

    I don't have an Options button
    But thanks for the reminder.
    This does work, but for some reason you can't have Formula and Cells




    On Tue, 18 Jul 2006 18:35:24 +0100, Dave Peterson =

    <[email protected]> wrote:

    > Why can't you search them easily?
    >
    > Edit|find|Options button|Look in Dropdown|Comments
    >
    > "DB." wrote:
    >>
    >> On Tue, 18 Jul 2006 15:46:16 +0100, DB. <[email protected]> =

    =

    >> wrote:
    >>
    >> > I have two workbooks which have comments on a few of their cell=

    s.
    >> > As is appropriate, when I point to each of those cells the =


    >> comments
    >> > they contain appear alongside.
    >> > But often (not always), after I have saved the workbook then =


    >> opened
    >> > it up again on my return, I find that none of my comments appears =


    >> when I
    >> > point at it.
    >> > Comments can be made visible again by selecting any cell =


    >> containing a
    >> > comment, clicking Insert --> Edit Comment, then exiting without =


    >> changing
    >> > anything. All comments on that worksheet are now available to me.
    >> > Next time I return to the workbook my comments may be available=

    - =

    >> or,
    >> > equally, they may not.
    >> > Can anyone explain to me what is happening here, please?
    >> >

    >>
    >> "SteveW" replied:
    >>
    >> Nobody at Microsoft can explain comments
    >>
    >> I have a file with a major use for comments - its a real pain in the =

    =

    >> neck.
    >> Like you say they jump up all over the place when you go to edit them=

    ..
    >> you can't search them (easily)
    >>
    >> They could have been a really useful addition but imo they (Microsoft=

    )
    >> missed a trick here.
    >>
    >> Thanks, Steve.
    >>
    >> I now notice that if I have my worksheet (comments available) ope=

    n =

    >> in
    >> one window and open Outlook Express in another, then the comments are=

    no
    >> longer available. But my workbook has two sheets, and if I tab to the=

    =

    >> other
    >> sheet, then tab back again I get the comments again!
    >> I imagine your "Nobody at Microsoft can explain comments " may =

    =

    >> best
    >> sum it up!
    >> --
    >> BW's,
    >> DB.

    >




    -- =

    Steve (3)

  6. #6
    Dave Peterson
    Guest

    Re: Comments.

    What do you mean by Formula and Cells?

    If you mean: Formula and Comments?

    Then, yep. You have to do it twice.





    SteveW wrote:
    >
    > I don't have an Options button
    > But thanks for the reminder.
    > This does work, but for some reason you can't have Formula and Cells
    >
    > On Tue, 18 Jul 2006 18:35:24 +0100, Dave Peterson
    > <[email protected]> wrote:
    >
    > > Why can't you search them easily?
    > >
    > > Edit|find|Options button|Look in Dropdown|Comments
    > >
    > > "DB." wrote:
    > >>
    > >> On Tue, 18 Jul 2006 15:46:16 +0100, DB. <[email protected]>
    > >> wrote:
    > >>
    > >> > I have two workbooks which have comments on a few of their cells.
    > >> > As is appropriate, when I point to each of those cells the
    > >> comments
    > >> > they contain appear alongside.
    > >> > But often (not always), after I have saved the workbook then
    > >> opened
    > >> > it up again on my return, I find that none of my comments appears
    > >> when I
    > >> > point at it.
    > >> > Comments can be made visible again by selecting any cell
    > >> containing a
    > >> > comment, clicking Insert --> Edit Comment, then exiting without
    > >> changing
    > >> > anything. All comments on that worksheet are now available to me.
    > >> > Next time I return to the workbook my comments may be available -
    > >> or,
    > >> > equally, they may not.
    > >> > Can anyone explain to me what is happening here, please?
    > >> >
    > >>
    > >> "SteveW" replied:
    > >>
    > >> Nobody at Microsoft can explain comments
    > >>
    > >> I have a file with a major use for comments - its a real pain in the
    > >> neck.
    > >> Like you say they jump up all over the place when you go to edit them.
    > >> you can't search them (easily)
    > >>
    > >> They could have been a really useful addition but imo they (Microsoft)
    > >> missed a trick here.
    > >>
    > >> Thanks, Steve.
    > >>
    > >> I now notice that if I have my worksheet (comments available) open
    > >> in
    > >> one window and open Outlook Express in another, then the comments are no
    > >> longer available. But my workbook has two sheets, and if I tab to the
    > >> other
    > >> sheet, then tab back again I get the comments again!
    > >> I imagine your "Nobody at Microsoft can explain comments " may
    > >> best
    > >> sum it up!
    > >> --
    > >> BW's,
    > >> DB.

    > >

    >
    > --
    > Steve (3)


    --

    Dave Peterson

  7. #7
    SteveW
    Guest

    Re: Comments.

    typo

    Back to the OP, I have a set of macros that create a comment, of specifi=
    c =

    size, style etc
    with initial contents.
    These stay happily with the cell whenever I edit them
    But if lines of the sheet are hidden before the cell with the comment,
    then Comment Edit, brings up the comment *where it would have been if th=
    e =

    lines hadn't been hidden*

    Fine if it's one or two, but a hundred or more out is annoying, especial=
    ly =

    when the current cell is moved off the screen to show the comment and th=
    en =

    when the comment edit is finished, the screen doesn't move back to where=
    =

    it was

    Steve

    On Tue, 18 Jul 2006 22:43:20 +0100, Dave Peterson =

    <[email protected]> wrote:

    > What do you mean by Formula and Cells?
    >
    > If you mean: Formula and Comments?
    >
    > Then, yep. You have to do it twice.
    >
    >
    >
    >
    >
    > SteveW wrote:
    >>
    >> I don't have an Options button
    >> But thanks for the reminder.
    >> This does work, but for some reason you can't have Formula and Cells
    >>
    >> On Tue, 18 Jul 2006 18:35:24 +0100, Dave Peterson
    >> <[email protected]> wrote:
    >>
    >> > Why can't you search them easily?
    >> >
    >> > Edit|find|Options button|Look in Dropdown|Comments
    >> >
    >> > "DB." wrote:
    >> >>
    >> >> On Tue, 18 Jul 2006 15:46:16 +0100, DB. <[email protected]=

    m>
    >> >> wrote:
    >> >>
    >> >> > I have two workbooks which have comments on a few of their =


    >> cells.
    >> >> > As is appropriate, when I point to each of those cells the
    >> >> comments
    >> >> > they contain appear alongside.
    >> >> > But often (not always), after I have saved the workbook then=


    >> >> opened
    >> >> > it up again on my return, I find that none of my comments appear=

    s
    >> >> when I
    >> >> > point at it.
    >> >> > Comments can be made visible again by selecting any cell
    >> >> containing a
    >> >> > comment, clicking Insert --> Edit Comment, then exiting without
    >> >> changing
    >> >> > anything. All comments on that worksheet are now available to m=

    e.
    >> >> > Next time I return to the workbook my comments may be =


    >> available -
    >> >> or,
    >> >> > equally, they may not.
    >> >> > Can anyone explain to me what is happening here, please?
    >> >> >
    >> >>
    >> >> "SteveW" replied:
    >> >>
    >> >> Nobody at Microsoft can explain comments
    >> >>
    >> >> I have a file with a major use for comments - its a real pain in t=

    he
    >> >> neck.
    >> >> Like you say they jump up all over the place when you go to edit =


    >> them.
    >> >> you can't search them (easily)
    >> >>
    >> >> They could have been a really useful addition but imo they =


    >> (Microsoft)
    >> >> missed a trick here.
    >> >>
    >> >> Thanks, Steve.
    >> >>
    >> >> I now notice that if I have my worksheet (comments available) =

    =

    >> open
    >> >> in
    >> >> one window and open Outlook Express in another, then the comments =

    =

    >> are no
    >> >> longer available. But my workbook has two sheets, and if I tab to =

    the
    >> >> other
    >> >> sheet, then tab back again I get the comments again!
    >> >> I imagine your "Nobody at Microsoft can explain comments " m=

    ay
    >> >> best
    >> >> sum it up!
    >> >> --
    >> >> BW's,
    >> >> DB.
    >> >

    >>
    >> --
    >> Steve (3)

    >




    -- =

    Steve (3)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1