Hello
I am trying to make a save&close workbook macro.
I found several examples on google, but unfortunatly it conflicts with another macro I use for forceing users to enable macros (hide all sheets except one if macros are disabled).
The attached file is an example contaning the save&close code and the show/hide sheets depending on macros enabled.
If the file is opened with macros disabled then only one sheet will be visible.
If the file is opened with macros enabled other sheets are visible.
The problem if that this code uses a custom save, witch makes the save&close not save... (in module1 and in ThisWorkbook)
The pourpose of the save&close is to make sure some users don't forget the excel open and thus block access to it. So if a certain idle time passes excel has to save and close without any confirmation messages.
Since I cannot upload on the forum an xls file to show exactly the problem, I uploaded a dummy xls here:
http://www.wikiupload.com/download_page.php?id=181235
Can anyone help me adjust the code in the attached file so that it saves before auto closing?
Thank you
I am trying to make a save&close workbook macro.
I found several examples on google, but unfortunatly it conflicts with another macro I use for forceing users to enable macros (hide all sheets except one if macros are disabled).
The attached file is an example contaning the save&close code and the show/hide sheets depending on macros enabled.
If the file is opened with macros disabled then only one sheet will be visible.
If the file is opened with macros enabled other sheets are visible.
The problem if that this code uses a custom save, witch makes the save&close not save... (in module1 and in ThisWorkbook)
The pourpose of the save&close is to make sure some users don't forget the excel open and thus block access to it. So if a certain idle time passes excel has to save and close without any confirmation messages.
Since I cannot upload on the forum an xls file to show exactly the problem, I uploaded a dummy xls here:
http://www.wikiupload.com/download_page.php?id=181235
Can anyone help me adjust the code in the attached file so that it saves before auto closing?
Thank you
