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

[xdciro]

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 (https://www.mrexcel.com/forum/excel...se-excel-file-after-some-time-inactivity.html, http://www.vbaexpress.com/kb/getarticle.php?kb_id=379)

So what I basically did was that I joined all of these Macros in one Workbook.

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

 

[Zubair Muhammad]

Hi Ciril,

Add the code below in Workbook_beforeclose event

ThisWorkbook.Saved = True

Once Saved property is set to True, Excel responds as though the workbook has already been saved and no changes have occurred since that last save.


ALTERNATIVELY

This should work as well

<code class="x-hidden-focus">    Application.DisplayAlerts = False
    ActiveWorkbook.Close
    Application.DisplayAlerts = True</code>

 

[Jaafar Tribak]

@Zubair Muhammad
Hi,

Yes but setting the Saved Property to TRUE will discard any changes made to the workbook which is not what is supposed to happen.

 

[Zubair Muhammad]

Are you using

Thisworkbook.Save

in the Workbook_Close event?