hi
not sure why you need it in the middle but if you just want it to show and
click in the "cell"...just leave out the captions. size the checkbox to the
size of the cell, not caption, set background to transparent. that way all
you would see is the checkable box and clicking anywhere in the "cell" would
be clicking the checkbox control not just the small checkable box and set the
checkbox control to true or false.
not what you wanted but maybe a work around????

regards
FSt1


"Leonid L" wrote:

.... So that, a click anywhere within the cell should trigger the
checkbox. I was not able to do that because the checkbox is always
placed right next to the left side of it's clickable area. If only I
could change that alignment to "middle" somehow, all my problems would
go away.

Eventually I want to do this programmatically, but manual steps are
also welcome, as I can just record a macro. This has to work in
Excel2003, so I want to use the simplest type of checkboxes available.

Many thanks.