Automate a macro based on the value of a cell? (call Sub)
Here it is:
1. I have a muti-sheet workbook
2. I have buttons on several sheets that call Subroutines
that assign default values -- they work fine.
The problem: How can I run one of those macros/Sub
automatically when some cell goes, say TRUE to FALSE?
Specifically, from Sheet1 I want to run the code attached
to Button2 on Sheet2.
Help,
Doug
|