Check Box - are they possible with a shared workbook?

L

Lisa

I have a "shared" spreadsheet with a column containing check boxes (Forms
Toolbar). When another user checks the box it doesn't show up on my saved
version. Is there a way around this?? Working with Office 2000. Thanks
 
D

Dave Peterson

If I added a linked cell, the checkboxes (and the linked cell) updated.

Maybe you can do that?
 
L

Lisa

Thanks Dave. Linking the check box to a cell totally works. But now, is
there a way I can just have a check box without it stating true (if checked)
and false (if not checked)?? Basically, I just want a check box in my
workbook that another user can use, but I only want it to be checked or not =
no words.
Thanks in advance.
 
D

Dave Peterson

I couldn't do it without the linked cell.

But you can put that cell in a column and hide the column--or you could put it
 
D

Dave Peterson

One more.

I like to put the linked cell in the cell that's below the checkbox.

But then I use a custom format of:
;;;
(3 semicolons)
to make it look like that cell is blank
 
Top