Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2009

    Unanswered: conflict between auto save&close macro and show/hide sheets macro


    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 (change .txt to .xls).

    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:
    and here:
    Attached Files Attached Files
    Last edited by alexandruc; 10-19-09 at 13:14.

  2. #2
    weejas is offline Grumpy old man (training)
    Join Date
    Sep 2006
    Surrey, UK
    Provided Answers: 18
    Have you tried stepping through the processes? That can sometimes show where problems occur.
    10% of magic is knowing something that no-one else does. The rest is misdirection.
    Beers earned: 2

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts