LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22
Default "Kicking Out" Inactive Users

I have a file that only allows one user at a time to have write/update
authority (first one in locks it up); there are five people with this
modification authority. The problem is one of them opening it and then
walking away for an extended period of time and thus the others cannot input
their updates. I do not want to make it into a shared file.

Similar to my company's auto password protected screen saver (kicks on after
"x" number of inactive minutes), I would to have the file save itself and
close if a write/update user hasn't navigated in the file via keyboard or
mouse in say the last three minutes. Ideally, anyone who opened the file with
€śread only€ť clearance (approximately a dozen users preset as Read Only) would
not get €śkicked out€ť as they are not disrupting anyone.

Any clues / insight?

Regards,
Mike
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Prevent users from changing the password roel1973 Excel Discussion (Misc queries) 1 April 5th 06 01:21 PM
Protect Workbook vs Worksheet?? Dan B Excel Worksheet Functions 3 November 7th 05 09:02 PM
How many users can sucessfully use a shared excel workbook? Andrew of EIT Excel Worksheet Functions 1 September 5th 05 02:45 PM
How do I allow users to make a choice in a worksheet? Jim Zavone Excel Worksheet Functions 2 June 23rd 05 12:09 PM
Protecting Workbook Paul Cooling Excel Discussion (Misc queries) 2 March 7th 05 11:55 AM


All times are GMT +1. The time now is 01:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"