Help Please – Format Comments (Excel 2002)

Topic

New Reply

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

Reply | Quote

Replies

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

Reply | Quote

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……

Reply | Quote

That shouldn’t happen, but occasionally, saving changes to one setting in the Display Properties control panel resets others.
You’ll have to set the background again in the Desktop tab of the Display Properties control panel.

Reply | Quote

No worries…….

Thanks again!!!!!!!!

Reply | Quote