Results 1 to 4 of 4

Thread: comment tag

  1. #1
    Join Date
    Sep 2006
    Posts
    162

    Unanswered: comment tag

    anyway to change the color of the comment tag thats in the top right corner?

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    For all comments? Or individual ones? For individual ones, while editing the comment, click the border and choose line color from the drawing toolbar.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Sep 2006
    Posts
    162
    Rgr, I just found a macro to draw over each one, works nicely for me.

    Is there a way to format all comments at the same time, or set a default format??

    I also have a macro to record comments to another sheet with the corrasponding sheet and cell listed, is there a way to do the reverse, add comments from a table that has the sheet, cell, and data???
    Last edited by Jay59; 09-28-06 at 23:35.

  4. #4
    Join Date
    Sep 2006
    Posts
    162
    never mind, i have a macro for that now.

    Thanks

Posting Permissions

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