View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
chad chad is offline
external usenet poster
 
Posts: 273
Default Simple Check Box - without True/False values

Perhaps you could try leaving the linked cell in the workbook, but hide the
entire column of linked cells. For example, the linked cell for the first
checkbox is in cell d1 and the seond in d2, etc. Hide column D so the user
cannot see these values but the checkboxes maintain their checked or
unchecked value.

-Chad


"Lisa" wrote:

That does work, however, I need this check box to be functional in a "shared"
workbook. The only way another user can check the box and check to remain is
when it is linked to a cell. More details....I've created a workbook that
will have a running check list that I need another user to check the boxes
when an item is received. But it just needs to be a simple check or no
check. Any advice?
Thanks.

"Chad" wrote:

In the properties for the check box, remove the linked cell value. This
should allow simply a check box with no referenced cell reporting a
True/False value.

-Chad

"Lisa" wrote:

I would like a simple check box which can be either checked or unchecked but
with no text values. I don't want it to say "true" or "false", just blank.
Can this be done? I'm using Excel 2000, and I'm a novice with this whole
check box thing.
Thank you.