I need some help, I have tried both the codes from the previous posts on Auto closing and saving a work book, but my work book still will not close.
When the message comes up on the sample, if you don't click OK, it just stays open with the message on the screen. I want the workbook to close, because some one left it unattended so I don't need a count down clock. My workbook has 9 sheets in it. Could that be a problem?
I have copied the code staright froom the formum into my workbook under the proper places of Workbook and module.
The samples work, as far as closing within a minute, but when I paste the code into my WB, nothing happens.
Any thoughts out there?
Thanks in advance