MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Comments box


Posted by Jack in the Uk on February 03, 2002 12:37 PM

Hi guys,

Anyone know how to change the excel default boaring square box to someting more intresting, so something from clipart which still need test to be added, or even custom balloon!

Any ideas guys, also where whould the graphic go?

Cheers
Rdgs
Jack in the UK


Posted by Ivan F Moala on February 03, 2002 1:41 PM

Jack
The comments shape is part of the sheets shapes.
So you can change the shape of the comment via
the Drawings toolbar.

Goto Draw > Change Autoshape

From here you can change it to what ever you like
eg.&Lines,Co&nnectors,&Basic Shapes,Block &Arrows
&Flowchart,&Stars and Banners,&Callouts
&More AutoShapes...

To change the fill to a Pict is STD with all shapes.
Right Click | format comment


enjoy

Ivan

Posted by Jack in the UK on February 03, 2002 2:19 PM

Ivan . 100 thanks .. i have won another beer on that... [NT]