I'm having a problem getting a workbook to close without asking for a save. I posted this question before and was told to enter this code in the "ThisWorkbook" module.
This worked for a day or so and then quit working. What has happened or is the the wrong code to make the sheet close without asking to Save?
Please Login or Register to view this content.
Last edited by rkjudy; 05-07-2014 at 05:14 PM.
Is this solved?
If you solve a problem yourself before anyone else has responded, please take a moment to describe your solution, chances are some other member will benefit.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Hi, rkjudy,
any Auto_Open or Auto_Close procedures belong into a standard module and not into ThisWorkbook where Workbook_Open or Workbook_Close should be used.
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks