 Free Microsoft Office Help for all Applications! |
Excel VBA Help |
|
|
|
|
)
|
|
|||||||
| Microsoft Excel Forum Members Post questions in this forum if they are related to using Microsoft Excel, this includes Worksheet Functions, Excel VBA Programming, Simple Macro Code & Charting, Excel formula etc. |
| New Reply |
|
|
LinkBack | Thread Tools | Rate Thread | Display Modes |
19th October 2009, 15:21
|
||||
|
||||
conflict between auto save&close macro and show/hide sheets macro
Excel: VBA
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. Can anyone please help me adjust the code in the attached file so that it saves before auto closing? Thank you p.s: I raised the same problem with no success so far here: conflict between auto save&close macro and show/hide sheets macro - Excel Help Forum here: conflict between auto save&close macro and show/hide sheets macro - dBforums and here: conflict between auto save&close macro and show/hide sheets macro - MrExcel Message Board Last edited by alexandruc; 19th October 2009 at 17:11. |
| The Code Cage Advertisment | ||
| ||
|
|
19th October 2009, 15:49
|
||||
|
||||
Re: conflict between auto save&close macro and show/hide sheets macro
Warning
|
|
19th October 2009, 15:50
|
||||
|
||||
Re: conflict between auto save&close macro and show/hide sheets macro
Warning
|
| The Code Cage Advertisment | ||
| ||
|
|
|
19th October 2009, 17:13
|
||||
|
||||
Re: conflict between auto save&close macro and show/hide sheets macro
Warning
|
|
19th October 2009, 17:16
|
||||
|
||||
Re: conflict between auto save&close macro and show/hide sheets macro
Warning
Last edited by alexandruc; 19th October 2009 at 17:21. |
|
19th October 2009, 17:53
|
||||
|
||||
Re: conflict between auto save&close macro and show/hide sheets macro
Warning
__________________
Regards, Simon Lloyd Microsoft Office Help
Want to say thanks? then hit this
 button in any post you want to thankIf you find one of my posts helpful then hit this one  in the post that helped most!
|
| The Code Cage Advertisment | ||
| ||
|
To stop seeing these ads and get other benefits check This page! |
|
19th October 2009, 18:04
|
||||
|
||||
Re: conflict between auto save&close macro and show/hide sheets macro
Warning
|
|
19th October 2009, 18:13
|
||||
|
||||
Re: conflict between auto save&close macro and show/hide sheets macro
Warning
|
|
19th October 2009, 18:32
|
||||
|
||||
Re: conflict between auto save&close macro and show/hide sheets macro
Warning
|
| The Code Cage Advertisment | ||
| ||
|
To stop seeing these ads and get other benefits check This page! |
|
19th October 2009, 19:24
|
||||
|
||||
Re: conflict between auto save&close macro and show/hide sheets macro
Warning
__________________
Regards, Simon Lloyd Microsoft Office Help
Want to say thanks? then hit this
button in any post you want to thankIf you find one of my posts helpful then hit this one in the post that helped most!
|
| The Code Cage Advertisment | ||
| ||
|
To stop seeing these ads and get other benefits check This page! |
| New Reply |
| Tags |
| auto, conflict, macro, saveandclose, sheets, show or hide |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
The Code Cage Affilliates
|
Linear Mode
