How do I change the Font Default for Comment in Excel 2000?

I have Excel 2000 and the default font for comments is Tahoma, size 8, in Bold.
I'd like to be able to change the default comment to Arial 10.
Now I have to change each individual comment and it's getting to be a real
pain. How do I change the default?

Also, when I "Insert Comment", there is a ":" inside the comment and I have
to delete it every time. Somehow the ":" is in a default somewhere and I
can't find where it is so that I can delete it permanently. Please help!!

Thanks, Karla

"Karla" wrote
> I have Excel 2000 and the default font for comments is
> Tahoma, size 8, in Bold.
> I'd like to be able to change the default comment to Arial 10.
> Now I have to change each individual comment and it's getting to be a real
> pain. How do I change the default?

To change font *size*, you could try this (It's a windows setting)
Right-click on any empty space in the desktop > choose Properties

Select Appearance tab > Advanced button
(in Win XP)

In the Advanced Appearance dialog:
Click on "Item" dropdown menu > choose Tooltip
Choose a font size > OK > Apply

To change font *type*, try Debra's page at:
http://www.contextures.on.ca/xlcomments03.html
(Look for the header: "Insert a Formatted Comment")

> Also, when I "Insert Comment", there is a ":" inside the comment and I
have
> to delete it every time. Somehow the ":" is in a default somewhere and I
> can't find where it is so that I can delete it permanently. Please help!!

In Debra's page above, look for "Insert a Plain Comment" where she provides
a macro Sub CommentAddOrEdit() which inserts a comment with no User Name.
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--

Thank you Max - I'll check these out!

"Max" wrote:

> "Karla" wrote
> > I have Excel 2000 and the default font for comments is
> > Tahoma, size 8, in Bold.
> > I'd like to be able to change the default comment to Arial 10.
> > Now I have to change each individual comment and it's getting to be a real
> > pain. How do I change the default?
>
> To change font *size*, you could try this (It's a windows setting)
> Right-click on any empty space in the desktop > choose Properties
>
> Select Appearance tab > Advanced button
> (in Win XP)
>
> In the Advanced Appearance dialog:
> Click on "Item" dropdown menu > choose Tooltip
> Choose a font size > OK > Apply
>
> To change font *type*, try Debra's page at:
> http://www.contextures.on.ca/xlcomments03.html
> (Look for the header: "Insert a Formatted Comment")
>
> > Also, when I "Insert Comment", there is a ":" inside the comment and I
> have
> > to delete it every time. Somehow the ":" is in a default somewhere and I
> > can't find where it is so that I can delete it permanently. Please help!!
>
> In Debra's page above, look for "Insert a Plain Comment" where she provides
> a macro Sub CommentAddOrEdit() which inserts a comment with no User Name.
> --
> Rgds
> Max
> xl 97
> ---
> Singapore, GMT+8
> xdemechanik
> http://savefile.com/projects/236895
> --
>
>
>

You're welcome !
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Karla" <Karla@discussions.microsoft.com> wrote in message
news:BD41826E-AE9B-4015-9C1F-85EECF096080@microsoft.com...
> Thank you Max - I'll check these out!