Excel auto open and close

  Picklefactory 16:17 18 Apr 07
Locked

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.
Cheers

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

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…