Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 "Mike" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Increase size of a Forms Check Box (click on to enter check mark) | Excel Discussion (Misc queries) | |||
Check if Conditional Format is True or False / Check cell Color | Excel Worksheet Functions | |||
Enable check box in protected sheet + group check boxes | Excel Discussion (Misc queries) | |||
How do I set Checkboxes where you can only check yes or no, not bo | Excel Worksheet Functions | |||
How do I check/uncheck ten or odd Checkboxes by click on one check | Excel Discussion (Misc queries) |