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.
Microsoft Excel
Last Comment
Bright01
Can you post your file?
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
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.