Excel auto open and close

  Picklefactory 16:17 18 Apr 2007

OK, this might sound mad but here go's.
We have an ever expanding series of progress sheets that track delivery on numerous independent projects. They are, for internal reasons, all seperate workbooks and need to remain so. I have sussed a way to auto send an email from each workbook based on any overdue deliveries. That works fine as far as it go's. My problem is that the workbook has to be opened to run the code. The guys who use these will only open what ever wbook they are currently working on each day, which is no good as I want a daily check on overdue items across the spectrum. What I would like, is some sort of stand alone selection sheet with project list and a means (Maybe checkboxes) where we can specify current live projects and deselect dead/complete ones and somehow automatically open and close the live workbooks just to run the check. Is this just wishful thinking, or does it sound feasible?
Hope that makes some sense.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

Galaxy Note 8 vs iPhone X

Awful clip art from 1994 is being tweeted every hour by a bot

How to update iOS on iPhone or iPad

Les meilleures applications pour enfants 2017