Results 1 to 5 of 5
  1. #1
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Help Please - Format Comments (Excel 2002)

    Hi,

    Please could somebody help an 'excel novice', please...........

    When I insert a comment, the standard format is 'Tahoma, Size 8' which is difficult to view. How do I change the settings to a different font as standard??

    Many Thanks

    VegasNath

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

    Re: Help Please - Format Comments (Excel 2002)

    Welcome to Woody's Lounge!

    If Excel 2007 acts the same as earlier versions, you cannot change Tahoma as default font for comments - it appears to be hard-coded. You *can* change the font size and other characteristics, but you will have to do this in Windows and it will affect all "tooltips":

    - Right-click an empty part of your Windows desktop.
    - Select Properties from the popup menu.
    - Activate the Appearance tab.
    - Click Advanced.
    - Select Tooltip from the list of items.
    - Change the font size etc.
    - OK your way out.

    This will only apply to new comments you create from now on. For existing comments, you can run a macro to adjust their font and size, for example.

    Sub FixComments()
    Dim cmt As Comment

    For Each cmt In ActiveSheet.Comments
    With cmt.Shape.TextFrame.Characters.Font
    .Name = "Times New Roman"
    .Size = 12
    End With
    Next cmt
    End Sub

  3. #3
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help Please - Format Comments (Excel 2002)

    Thanks Hanz, I really appreciate your help!

    I have changed the font size as suggested which has worked fine,but on doing so, my windows backround has been robbed!!! Any idea's?

    Thanks again......

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

    Re: Help Please - Format Comments (Excel 2002)

    That shouldn't happen, but occasionally, saving changes to one setting in the Display Properties control panel resets others. <img src=/S/sad.gif border=0 alt=sad width=15 height=15>
    You'll have to set the background again in the Desktop tab of the Display Properties control panel.

  5. #5
    Bronze Lounger
    Join Date
    Sep 2007
    Posts
    1,203
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Help Please - Format Comments (Excel 2002)

    No worries.......

    Thanks again!!!!!!!!

Posting Permissions

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