Results 1 to 6 of 6
  1. #1
    2 Star Lounger
    Join Date
    Dec 2001
    Location
    Houma, Louisiana, USA
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts

    default font for comments (Office 2003)

    Is there a way to tell excel to use a particular font / font size when entering comments? Every time I enter a comment it defaults to a size 8 font and I have to change the font size so I can read it.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: default font for comments (Office 2003)

    See the thread starting at <post#=233738>post 233738</post#>. The default font is controlled by the Windows display setting for tooltips, but the replies in that thread suggest some workarounds.

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: default font for comments (Office 2003)

    In addition <post#=290956>post 290956</post#> has some code to globally change the properties of all the comments on the sheets (after they have been created). It even eliminates the "username" (if desired)

    Steve

  4. #4
    2 Star Lounger
    Join Date
    Dec 2001
    Location
    Houma, Louisiana, USA
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: default font for comments (Office 2003)

    Hans, thanks for replying so quickly. Changing the windows tooltips setting was all I needed to do. I never would have figured that one out on my own.

  5. #5
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: default font for comments (Office 2003)

    Note: this changes the font for ALL tooltips in every program (not just excel comments), which might not be what you want...

    Steve

  6. #6
    2 Star Lounger
    Join Date
    Dec 2001
    Location
    Houma, Louisiana, USA
    Posts
    100
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: default font for comments (Office 2003)

    Thanks Steve. I saw that, but don't really care whether the name pops up or not. It's good to know that I can change that if I want to though. <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

Posting Permissions

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