Reset Button Works Once

I can't see why it wouldn't work. You'll have to upload a sample worksheet.

It works for me. I did the following on sheet "CTR 1":

1. Made sure calculation setting was set to Automatic
2. Pressed the button to clear the data already in the sheet
3. Refilled in data to the checkboxes and the input cells
4. Pressed the button again, the data clears, and the sheet resets
5. Repeating this process yields the same results

Same results for the other sheets.


What happens specifically when you press the button the second time (and it doesn't reset)?

Ok, I've managed to replicate your problem in Excel 2010 by doing the following:

1. Open your sheet
2. Create three new windows through View > New Window
3. Tile the windows through View > Arrange All > Tiled
4. Change each window to a different CTR sheet
5. Only the ActiveX button in the parent (1) window works


To be honest when I first saw your sheet I did wonder why you used the more complicated ActiveX buttons instead of simple Form Control buttons.

I added normal buttons to your sheets with the following method:

1. Developer > Insert > (Section: Form Controls) Button
2. Draw the button
3. Click Cancel on the "Assign Macro" window
4. Open VBA Editor with ALT + F11
5. Created a new module called "Buttons"
6. Added a sub called "Button1_Click" and filled in the appropriate code
7. Right click on the button in the sheet, click "Assign Macro", and choose "Button1_Click"
8. Repeated steps 1-4 and 6-7 for the remaining buttons ("Button2_Click" etc.)

Repeating the test showed that the form control buttons work in split windows where the ActiveX buttons do not. I don't know why this happens as I rarely, if ever, use ActiveX controls. I find it's best to use Form Controls as they are a lot simpler to setup, use, and manage. In cases that you need to use ActiveX controls... you'll know beforehand.

See attached spreadsheet for a working example

Hope this helps!

No worries, we never stop learning

---

If that takes care of your original question, please select Thread Tools from the menu link above to mark this thread as SOLVED.
To say thanks to the user(s) who contributed towards the solution, you can use the "Add Reputation" button on their helpful post(s).
Thanks!