I think this is a really unique problem. I have a worksheet that has a macro setup in it to send emails if a cell's value equals the date that the worksheet is opened. In other words. if I open the worksheet and cell A1's date equals that days date, the macro runs. If the date doesn't match, the macro doesn't run. Simple enough. Here's my problem. I need it to run once a week automatically with out having to open it. Again, simple enough. I did this by creating a scheduled task so it opens on its own and closes on its own also. That the kicker. Since its set up to open, run, and then close ...how do I keep this from running when its opened manually,( to input data, but still run completely when its opened on a scheduled task. If the person opens its manually, the macro runs and it closes. I need it to do this ONLY when its opened on a schedule.
I sincerely hope this is not as confusing as it sounds.
Thanks