I want to insert some check boxes in a spread sheet. I just want to be able
to click on the box and have the check appear and click on it again to have
it disappear. I don't want any data related to this box...can this be done?

Thanks

View|toolbars|
show the forms toolbar
There's a checkbox on that toolbar.
click on it once

draw a little rectangle where you want the checkbox.

(If you double click on the checkbox, you can draw multiple checkboxes. Click
on that icon or hit the escape key to stop.)

If you hold the alt key while positioning the checkbox, it'll snap-to the cell's
edge.

(experiment with the shift key, too. And ctrl-dragging will copy the checkbox.)

Tangy wrote:
>
> I want to insert some check boxes in a spread sheet. I just want to be able
> to click on the box and have the check appear and click on it again to have
> it disappear. I don't want any data related to this box...can this be done?
>
> Thanks

--

Dave Peterson

THANKS!! how about change the colour of the check in the box?


"Dave Peterson" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> View|toolbars|
> show the forms toolbar
> There's a checkbox on that toolbar.
> click on it once
>
> draw a little rectangle where you want the checkbox.
>
> (If you double click on the checkbox, you can draw multiple checkboxes.
> Click
> on that icon or hit the escape key to stop.)
>
> If you hold the alt key while positioning the checkbox, it'll snap-to the
> cell's
> edge.
>
> (experiment with the shift key, too. And ctrl-dragging will copy the
> checkbox.)
>
> Tangy wrote:
>>
>> I want to insert some check boxes in a spread sheet. I just want to be
>> able
>> to click on the box and have the check appear and click on it again to
>> have
>> it disappear. I don't want any data related to this box...can this be
>> done?
>>
>> Thanks
>
> --
>
> Dave Peterson

Don't think you can.

How about an alternative?

Select your cells that should contain checkboxes:
(click on the first area, ctrl-click on subsequent)

format|cells|number tab|custom category
In the "type:" box, put this:

alt-0252;alt-0252;alt-0252;alt-0252

But hit and hold the alt key while you're typing the 0252 from the numeric
keypad.

It should look something like this when you're done.
ü;ü;ü;ü
(umlaut over the lower case u separated by semicolons)

And format that range of cells as Wingdings.

And then use whatever font color you want.

alt-251, alt-252, alt-253, and alt-254 all are different "styles" of checkboxes.

Then to check the box, just hit the spacebar (or any character).



Tangy wrote:
>
> THANKS!! how about change the colour of the check in the box?
>
> "Dave Peterson" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > View|toolbars|
> > show the forms toolbar
> > There's a checkbox on that toolbar.
> > click on it once
> >
> > draw a little rectangle where you want the checkbox.
> >
> > (If you double click on the checkbox, you can draw multiple checkboxes.
> > Click
> > on that icon or hit the escape key to stop.)
> >
> > If you hold the alt key while positioning the checkbox, it'll snap-to the
> > cell's
> > edge.
> >
> > (experiment with the shift key, too. And ctrl-dragging will copy the
> > checkbox.)
> >
> > Tangy wrote:
> >>
> >> I want to insert some check boxes in a spread sheet. I just want to be
> >> able
> >> to click on the box and have the check appear and click on it again to
> >> have
> >> it disappear. I don't want any data related to this box...can this be
> >> done?
> >>
> >> Thanks
> >
> > --
> >
> > Dave Peterson

--

Dave Peterson