cant run macro automatically and manual both

[kwik98]

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

[ARGK]

Hi
If I understand you correctly I would create a duplicate (working copy) of your workbook without the macros. Then create links to the data in both workbooks. Then any changes in your working copy will automatically be replicated in the other workbook.
Hope this helps.
Good luck.
Tony

[ragulduy]

Test for the time when it is running the macro, if this is at (or close to) the time the scheduler is set to, close the workbook, otherwise leave it open?

[romperstomper]

I'd use a different workbook in the scheduled task, which contains code to open your main workbook, run its macro and then close it, and itself. That way your main workbook doesn't need to auto close.