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.

What is ransomware and how do I protect my PC from WannaCry?

Disney layout supervisor Rob Dressel on the challenges of visualising Moana

Siri vs Google Assistant