Checkboxes don't work in merged cells

[AndyC812]

Version: 2004

Hi,

I've created a an application in Excel 2003 (PC) that contains a large number of checkboxes (from Forms toolbar).

When my clients on Macs use the application in Excell 2004 however, the checkboxes don't always function. Upon further inspection, it seems the checkboxes in merged cells do not function on the Mac. Has anyone run into this issue? Any advice on how to get these checkboxes functioning without a massive redesign of my Windows product?

Thanks,
Andy

 

[JE McGimpsey]

I've created a an application in Excel 2003 (PC) that contains a large number
of checkboxes (from Forms toolbar).

When my clients on Macs use the application in Excell 2004 however, the
checkboxes don't always function. Upon further inspection, it seems the
checkboxes in merged cells do not function on the Mac. Has anyone run into
this issue? Any advice on how to get these checkboxes functioning without a
massive redesign of my Windows product?

Checkboxes exist "in" the drawing layer, not "in" cells, so whether
cells are placed over merged cells or not doesn't matter.

It's not clear to me what you mean by "don't always function".

The first thing to check is whether the checkboxes are ActiveX
checkboxes or Forms toolbar checkboxes. If they are ActiveX, they won't
work on the Mac at all. There is nothing that can be done to change that
- use forms checkboxes instead.

If you're using Forms toolbar checkboxes - are the checkboxes linked to
the merged cells? That won't work in XL04/08.

That's yet another in the pantheon of reasons why merged cells are the
spawn of the devil and should never, ever be implemented. Friends don't
let friends merge cells. Even in Windows XL.