When a comment is inserted into an Excel worksheet, it is possible to
auto-size the comment box, in "insert comment" mode or "edit comment",
> mode by right-clicking on the border of the comment box, left-clicking on
> Format Comment>Alignment then putting a tick in the Automatic Size check
> box.
>
> Is it possible to set up the workbook so that the Automatic Sizing of the
> comment is the default state: ie. the comment is automatically "Automatic
> Size" -ed?


--
Joey
-------------------------------
Albert Einstein said:
"No amount of experimentation can ever prove me right; a single experiment
can prove me wrong."

If you want to wait and get them all at once, you can use some code at Debra
Dalgleish's site:

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



Joey wrote:
>
> When a comment is inserted into an Excel worksheet, it is possible to
> auto-size the comment box, in "insert comment" mode or "edit comment",
> > mode by right-clicking on the border of the comment box, left-clicking on
> > Format Comment>Alignment then putting a tick in the Automatic Size check
> > box.
> >
> > Is it possible to set up the workbook so that the Automatic Sizing of the
> > comment is the default state: ie. the comment is automatically "Automatic
> > Size" -ed?
>
> --
> Joey
> -------------------------------
> Albert Einstein said:
> "No amount of experimentation can ever prove me right; a single experiment
> can prove me wrong."

--

Dave Peterson
(E-Mail Removed)

Thanks Dave, for your direction. I have it up and running fine.

--
Joey
-------------------------------
Albert Einstein said:
"No amount of experimentation can ever prove me right; a single experiment
can prove me wrong."
"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> If you want to wait and get them all at once, you can use some code at
Debra
> Dalgleish's site:
>
> http://www.contextures.com/xlcomments03.html#Resize
>
>
>
> Joey wrote:
> >
> > When a comment is inserted into an Excel worksheet, it is possible to
> > auto-size the comment box, in "insert comment" mode or "edit comment",
> > > mode by right-clicking on the border of the comment box, left-clicking
on
> > > Format Comment>Alignment then putting a tick in the Automatic Size
check
> > > box.
> > >
> > > Is it possible to set up the workbook so that the Automatic Sizing of
the
> > > comment is the default state: ie. the comment is automatically
"Automatic
> > > Size" -ed?
> >
> > --
> > Joey
> > -------------------------------
> > Albert Einstein said:
> > "No amount of experimentation can ever prove me right; a single
experiment
> > can prove me wrong."
>
> --
>
> Dave Peterson
> (E-Mail Removed)