Bright01
asked on
Resetting a "Check Box"
EE Professionals,
I have two macros; One macro creates a set of tabs automatically, the other erases them and resets the model. I'm using a check box (instead of a button) to activate the create tabs macro and a button to reset the model. When I reset the model, the check box does not reset itself. I think it's one or two lines of macro code that resets the check box but do not know how to do it. Any help would be most appreciated.
B.
I have two macros; One macro creates a set of tabs automatically, the other erases them and resets the model. I'm using a check box (instead of a button) to activate the create tabs macro and a button to reset the model. When I reset the model, the check box does not reset itself. I think it's one or two lines of macro code that resets the check box but do not know how to do it. Any help would be most appreciated.
B.
Can you post your file?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Here you go. Just click the checkbox and it creates tabs. Hit the button and it resets but does not reset the check box.
Thank you!
Test-Case-for-generating-tabs.xls
Thank you!
Test-Case-for-generating-tabs.xls
ASKER
Thank you! Simple, clear and most importantly.... it worked!
B.
B.