Default Comment format (colour, font)

**Xx7** · 02-11-2011, 05:33 AM

I would like to create a macro to make a comment with Arial 8, blue font, light grey background and blue outline.. OR is there a way to change the default comment format to this. Thx!

**pike** · 02-11-2011, 07:38 AM

Hi Xx7

the best place to start is to record a macro of the steps

recorded macro...

Please Login or Register  to view this content.

then you cant change the the code to suit

**Xx7** · 02-11-2011, 08:32 PM

Doesn't work for me

font is default (tahoma), colour is black, and no background colour??

**pike** · 02-11-2011, 08:37 PM

hi Xx7
you can look at the code and change the values to suit

**pike** · 02-11-2011, 09:11 PM

sorry you will need to do a little more than that
this will change all the comments in the workbook font to arial 8 bold blue
and back ground to green

Please Login or Register  to view this content.

**Xx7** · 02-12-2011, 02:00 AM

Nice... it works

Having abit of trouble changing the below to the "light grey" color i'm looking for... tried the macro recorder with shapes, textboxes, comments... no luck

objcmt.Shape.Fill.ForeColor.SchemeColor = 3

**pike** · 02-12-2011, 02:04 AM

me either ,still looking

**pike** · 02-12-2011, 02:17 AM

Looks like they are the same as colorindex
so 22 works

Please Login or Register  to view this content.

**Xx7** · 02-12-2011, 03:05 AM

Beauty!!! case closed.

Thx Pike

**pike** · 02-12-2011, 03:20 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save