how do I Perminatly Format Comment Boxes in my Woorkbook?
 

I saw several answers that almost fit my Question. I would like to set up my
name & font in comment box once and for all in this bugbet workbook I am
doing.

Thank you for all the help I see happen here.
I am in the process of teaching myself excell .... lots of tips and tricks
to it but fun ....

how do I Perminatly Format Comment Boxes in my Woorkbook?
 

Do you want to change all existing Comments in existing workbooks?

You will need VBA macro to do that.

http://www.contextures.com/xlcomments03.html#Format

Or do you want to change the new workbooks default Comment font size.

http://www.contextures.on.ca/xlcomments02.html#Default

The default name in Comments is the name entered in
ToolsOptionsGeneralUser Name.


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 12:48:00 -0800, pageisbusy
wrote:

I saw several answers that almost fit my Question. I would like to set up my
name & font in comment box once and for all in this bugbet workbook I am
doing.

Thank you for all the help I see happen here.
I am in the process of teaching myself excell .... lots of tips and tricks
to it but fun ....

how do I Perminatly Format Comment Boxes in my Woorkbook?
 

Thank You I will set up a "defult" as i think i understand those directions.
I don't know what a VBA Macro(although i see you linked me to one) is or how
to put one in .... that will be a lesson for another day.
Thank You so much!
Page
I'm curious about the links you gave ... are they somthing you wrote or is
that here at microsoft somwhere? You must be a genious :-)

"Gord Dibben" wrote:

Do you want to change all existing Comments in existing workbooks?

You will need VBA macro to do that.

http://www.contextures.com/xlcomments03.html#Format

Or do you want to change the new workbooks default Comment font size.

http://www.contextures.on.ca/xlcomments02.html#Default

The default name in Comments is the name entered in
ToolsOptionsGeneralUser Name.


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 12:48:00 -0800, pageisbusy
wrote:

I saw several answers that almost fit my Question. I would like to set up my
name & font in comment box once and for all in this bugbet workbook I am
doing.

Thank you for all the help I see happen here.
I am in the process of teaching myself excell .... lots of tips and tricks
to it but fun ....

how do I Perminatly Format Comment Boxes in my Woorkbook?
 

The links are to a website designed, built and created by Debra Dalgleish.

Debra is a proud Canadian Excel MVP with exceptional ability who has
contributed greatly to these news groups.

Her site gets referenced many times a day by all the regular posters.

I am not a genius..............I just know where to look for the answers on
sites like Debra's.

When you're ready to tackle VBA post back..............you'll get lots of
help and direction.


Gord

On Tue, 13 Jan 2009 06:58:26 -0800, pageisbusy
wrote:

Thank You I will set up a "defult" as i think i understand those directions.
I don't know what a VBA Macro(although i see you linked me to one) is or how
to put one in .... that will be a lesson for another day.
Thank You so much!
Page
I'm curious about the links you gave ... are they somthing you wrote or is
that here at microsoft somwhere? You must be a genious :-)

"Gord Dibben" wrote:

Do you want to change all existing Comments in existing workbooks?

You will need VBA macro to do that.

http://www.contextures.com/xlcomments03.html#Format

Or do you want to change the new workbooks default Comment font size.

http://www.contextures.on.ca/xlcomments02.html#Default

The default name in Comments is the name entered in
ToolsOptionsGeneralUser Name.


Gord Dibben MS Excel MVP

On Mon, 12 Jan 2009 12:48:00 -0800, pageisbusy
wrote:

I saw several answers that almost fit my Question. I would like to set up my
name & font in comment box once and for all in this bugbet workbook I am
doing.

Thank you for all the help I see happen here.
I am in the process of teaching myself excell .... lots of tips and tricks
to it but fun ....