Check Box - are they possible with a shared workbook?
 

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

Check Box - are they possible with a shared workbook?
 

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

Maybe you can do that?

Lisa wrote:

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

--

Dave Peterson

Check Box - are they possible with a shared workbook?
 

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.

"Dave Peterson" wrote:

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

Maybe you can do that?

Lisa wrote:

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

--

Dave Peterson

Check Box - are they possible with a shared workbook?
 

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
on another sheet and hide that sheet.

Lisa wrote:

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.

"Dave Peterson" wrote:

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

Maybe you can do that?

Lisa wrote:

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

--

Dave Peterson


--

Dave Peterson

Check Box - are they possible with a shared workbook?
 

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

Dave Peterson wrote:

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
on another sheet and hide that sheet.

Lisa wrote:

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.

"Dave Peterson" wrote:

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

Maybe you can do that?

Lisa wrote:

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

--

Dave Peterson


--

Dave Peterson

--

Dave Peterson