Comment Fonts (once again!)

J

Jill Pleau

I have read all the tips and helps for the permanent change to Commen
fonts and have hit a couple of roadblocks.

1. All the tips refer to the XP Operating System in regards t
updating the Desktop display for "Tooltip". I cannot locate thi
option in WINNT 4.0. Does anyone have thoughts on this?

2. I am a lowly user and cannot figure out how to do the macro.

Do I have any other options here?

TIA, Jill

PS what does AFAIK mean
 
J

jeff

Hi,

AFAIK (as far as I know)

What are the tips to which you refer? can you post
a synopsis? also, what macro do you want to do.

HTH (happy to help)
jeff
 
J

Jill Pleau

Jeff,

I regularly add comments to cells in excel. The comment font i
defaulted to 8 pitch (unreadable) so I manually hilite and change th
font size. It would be helpful if I could make a permanent change t
this font size. Research on this site repeatedly points to th
following web site for a couple of solutions. Neither of the ‘fixes
will work for me either because of my PC’s limitations – or my own!

http://www.contextures.com/

Change the Default Font Size
You can change the font size of new comments by changing the setting
in your Control Panel.
(Instructions for Windows XP)
1. Right-click on the desktop, and choose Properties
2. On the Appearance tab, click Advanced.
3. From the Item dropdown, choose Tooltip
4. Choose a font Size, click OK, click OK


Insert a Formatted Comment
To insert a comment with no User Name, formatted in Times New Roma
font, use the following macro:
Sub CommentAddOrEditTNR()
'adds TimesNewRoman comment or positions
'cursor at end of existing comment text
Dim cmt As Comment
Set cmt = ActiveCell.Comment
If cmt Is Nothing Then
ActiveCell.AddComment text:=""
Set cmt = ActiveCell.Comment
With cmt.Shape.TextFrame.Characters.Font
.Name = "Times New Roman"
.Size = 11
.Bold = False
.ColorIndex = 0
End With
End If
SendKeys "%ie~"
End Sub

I have copied this macro and run it but it returns an error. I hav
also attempted to record my own macro but once again it returns a
error when I run it.

Thanks for any help you can give!

Jil
 
D

Debra Dalgleish

To change the default font size in WinNT 4.0:

Right-click on the desktop, and choose Properties
On the Appearance tab, from the Item dropdown, choose Tooltip
Choose a font Size, click OK

If you're running the macro from a button on the worksheet, in some
versions of Excel, you may get a 1004 error. To prevent this, add the
following line at the top of the macro:

ActiveCell.Activate
 
N

Norman Harker

Hi Jill!

Re: "PS what does AFAIK mean?"

<bg> Big grin <g> Grin <vbg> Very big grin <vbeg> Very big evil
grin

AFAIK As Far As I Know

BCNU Be Seeing You
BTW By the way

DARFC Ducks And Runs For Cover

DLG Devilish Little Grin
FAQ Frequently Asked Questions
FOTCL Falling Off The Chair Laughing
FWIW For What It's Worth

FUBAR Fouled up beyond all recognition
FYA For Your Amusement
FYI For Your Information

FLW Famous Last Words

GDR Grin duck run

HTH Hope This Helps

IIRC = "If I recall correctly"
IMHO In My Humble Opinion
IMNSHO In My Not So Humble Opinion
IMO In My Opinion
KISS Keep It Simple Stupid
LOL Laughing Out Loud (or Lots of love depending on context!)

NG News Group

OP Original Poster (i.e. Person who started the thread)

OT Off Topic (Often used to prefix subject line)
OTF On the floor. Short form of ROTFL.
OTOH On The Other Hand
PD Public Domain

PMFJI = Pardon me for jumping in
ROTFL Rolling On The Floor Laughing

RO(T)FL(MAO) = Rolling on(the) floor laughing (my ... off)
RTFM Read The Fine Manual. Used when a stupid question is asked

SNAFU Situation Normal, Another Foul Up
TIA Thank In Advance
TNX Thanks
TNX 1.0E6 Thanks a million (humorous)



Further sources:



http://www.ucc.ie/cgi-bin/uncgi/acronym

http://www.utdallas.edu/ir/tcs/techsupp/acronyms.html#C

http://www.acronymfinder.com

http://www.acronymdictionary.co.uk/
 
P

Peo Sjoblom

Hey Norman!

Don't forget BFD <vbg>

--


For everyone's benefit keep the discussion in the newsgroup.

Regards,

Peo Sjoblom
 
J

Jill Pleau

Thank you Debra! The 'Tooltip' is all I needed.

And Thanks for the education in acronyms Norman!

Jil
 
Top