ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Automatic Timeout & exit workbook (https://www.excelbanter.com/excel-programming/394956-automatic-timeout-exit-workbook.html)

Matts

Automatic Timeout & exit workbook
 
Hi,
I wish to put a timeout for my excel spreadsheet & it needs to work like this.

If there is any INACTIVITY on the sheet, (I'm also using 1 user-form to
accept feeds) there needs to be a message stating 'this bokk wil terminate in
'x' seconds owing to inactivity' & should close after that period

Important...The workbook on closing SHOULD NOT SAVE.
This excercise to close only this spreadsheet & not excel 'aplication'
(other spreadsheets shouldnt get affected)

Please explain where excatly i need to place the codes etc as I'm quite new
with programming.

Thnx in advance.

Tom Ogilvy

Automatic Timeout & exit workbook
 
http://groups.google.com

use *Excel* for the group and search on
inactivity close workbook

--
Regards,
Tom Ogilvy


"Matts" wrote:

Hi,
I wish to put a timeout for my excel spreadsheet & it needs to work like this.

If there is any INACTIVITY on the sheet, (I'm also using 1 user-form to
accept feeds) there needs to be a message stating 'this bokk wil terminate in
'x' seconds owing to inactivity' & should close after that period

Important...The workbook on closing SHOULD NOT SAVE.
This excercise to close only this spreadsheet & not excel 'aplication'
(other spreadsheets shouldnt get affected)

Please explain where excatly i need to place the codes etc as I'm quite new
with programming.

Thnx in advance.



All times are GMT +1. The time now is 07:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com