Hi, I have an excel 2007 sheet with several togglebuttons and checkboxes, and it worked fine few months ago. But today I have opened the file and nothing works. I have changed settings in Trust Center: 'Enable all macros' and checked the option in section called Programmer Macro Configuration.

It's strange, because I have no problem in a PC with Windows Vista (the PC in which I am having the problem is a Windows 7 64 bits).

In VBA editor, if I go to a piece of code and run it, i find there's some variables not defined (but anyway in the PC with Vista it works, like I said). One set of not defined variables is 'ToggleButton1', 'ToggleButton2', ...'ToggleButton12', all of them Boolean. These names match with the names of theToggleButton controls. Another set of not defined variables is 'CB1', 'CB2', ...'CB12', but also these names match with the names of other controls, the checkboxes ones. Thus, I think it's no needed to define these variables but the wronk working is due to the fact that the VBA editor doesn't find these controls in the sheet.

Thanks in advance for any help given.