Results 1 to 4 of 4

Thread: Workbook that forces users to enable Macros and automatically closes after some time

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. #1
    VBAX Newbie
    Joined
    Sep 2017
    Posts
    3
    Location

    Workbook that forces users to enable Macros and automatically closes after some time

    Hi,

    so I made a Workbook that does 2 things:
    1. It forces users to enable Macros and
    2. It automatically closes after being inactive for a defined amount of time

    The idea behind this is that only one user at the time would be able to use this file and that the file will automatically close after a certain time of being inactive. This will be useful if someone forgets to close a Workbook after using it (which can occur really often).

    I found all of necessary Macros on the web. So what I basically did was that I joined all of these Macros in one Workbook (see attachment)

    I ran into one problem. That is, that the workbook still wants a conformation for saving before closing. This prevents the closure of the workbook. Is there a way I could adjust the Macros so that this problem wont occur anymore.

    Thanks in advance and Kind Regards,

    Ciril
    Attached Files Attached Files

Posting Permissions

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