Unable to Check Checkboxes

[Guest]

I prepared a Workbook at work that has several Worksheets in it. One
Worksheet has a number of checkboxes in it. I can check the checkboxes fine
at work and so can my assistant. However, another of my associates is unable
to check the checkboxes and I am unable to check them on my home computer. I
am unable to find any solutions searching here or elsewhere.

Any ideas? Help!

Thanks,
Mike

 

[Guest]

This is just a shot in the dark, but if you created the checkboxes with the
Control Toolbox toolbar rather than from the Forms toolbar, they count as
macros. If, when you open the workbook at work, Excel asks whether you want
to enable macros but it doesn't do that when you open it at home, the problem
may be that your Excel installation at home has macro security set to high.
To remedy this, open Excel, execute a Tools/Options sequence, select the
Security tab, click on the Macro Security button, and set macro security to
medium (I think that it's a really bad idea to set it to low). Close the
Tools/Options dialog and exit Excel. Open Excel again and open the workbook.
Excel should asks you whether you want to enable macros, and things should
work. Or I may be on the wrong track completely.

Good luck with this.

Jim