Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2002
    Location
    Sydney, New South Wales, Australia
    Posts
    24
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Cell comments (2000)

    I am linking between worksheets to display a source cell's contents (from the 'Jul03' worksheet) onto another worksheet (the 'Posted' worksheet) using, for example, =Jul03!D7 . Does anyone know a way to make the comment attached to the source cell (D7) show up on the 'Posted' worksheet when using a link?

    Alex

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Cell comments (2000)

    About the only way I know of would be to use a maco. However, since inserting or editing a comment does not seem to trigger any events, it would be tough to make it automatic.
    Legare Coleman

Posting Permissions

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